AANAGRAM

[Xlambda]

AANAGRAM finds anagrams matches between 2 arrays. calls AKEEP , T_CHARS ,ATEXTJOIN , AUNQSRT

=LAMBDA(a,b,
    LET(x,AKEEP(a,T_CHARS(,2,),),y,AKEEP(b,T_CHARS(,2,),),
       z,ATEXTJOIN(AUNQSRT(MID(x,SEQUENCE(,MAX(LEN(x))),1),1),,,),v,ATEXTJOIN(AUNQSRT(MID(y,SEQUENCE(,MAX(LEN(x))),1),1),,,),
       IFNA(XMATCH(z,v),"-")
    )
)

LAMBDA 7.0.xlsx
	A	B	C	D	E	F	G	H
1			D3	=ATEXTJOIN(F3:F9,SEQUENCE(ROWS(F3:F9))&"-",,)
2	array a	=AANAGRAM(A3:A11,F3:F9)				array b
3	Stereophonics	2		1-Hairy Camera		Hairy Camera
4	Mariah Carey	1		2-Shoe Inspector		Shoe Inspector
5	Abbab	-		3-Rain Van		Rain Van
6	Is it a rum	6		4-See Ace Heck		See Ace Heck
7	Baba	7		5-Open at ten		Open at ten
8	Nirvana	3		6-Tiramisu		Tiramisu
9	Panettone	5		7-Abba		Abba
10	Cheesecake	4
11	Net at open	5
12
AANAGRAM post

Cell Formulas
Range	Formula
D1	D1	=FORMULATEXT(D3)
B2	B2	=FORMULATEXT(B3)
B3:B11	B3	=AANAGRAM(A3:A11,F3:F9)
D3:D9	D3	=ATEXTJOIN(F3:F9,SEQUENCE(ROWS(F3:F9))&"-",,)
Dynamic array formulas.