WR

[Xlambda]

WR: Word maze Results challenge. Please do see latest (26-Oct-21) YT video of MrExcel Solving Word Search With Excel (FMWC) - 2439
This is a compact set of functions that can solve all lookup scenarios.
Defined names: ar, sample array ( A1:T15 ) ; rw, nr. rows of sample array (15) (width is fixed to 20) ; cs, constant array values for "snake" lookup {-1,1, 20,-20} ; cd, constant array values for "diagonal" lookup {-21,-19,19,21}

WL(l)=LAMBDA(l,LET(x,IF(ar=l,1),y,IF(ar="?",1),z,IF(x+y,1),v,IF(z,SEQUENCE(rw,20)),SMALL(v,SEQUENCE(COUNT(v)))))
WA(a,c)=LAMBDA(a,c,LET(x,a-c,y,IF(x>0,x),UNIQUE(SMALL(y,SEQUENCE(COUNT(y ))))))
WB(a,b)=LAMBDA(a,b,FILTER(a,IFNA(XMATCH(a,b,,2),0)))
WR(w,c,[r],[i ])=LAMBDA(w,c,[r],[i ],LET(n,IF(i,i,LEN(w)),x,MID(w,n,1),y,MID(w,n-1,1),z,IF(AND(r=0),WA(WL(x),c),WA(r,c)),IF(n=1,r,WR(w,c,WB(z,WL(y )),n-1))))
Last one WR is !! recursive !! Define the names, then the functions and we are good to go. (Gaps in [i ] are to keep the text no to turn italics)
Will come back with the "concept" explanation asap.

=LAMBDA(w,c,[r],[i ],LET(n,IF(i,i,LEN(w)),x,MID(w,n,1),y,MID(w,n-1,1),z,
     IF(AND(r=0),WA(WL(x),c),WA(r,c)),IF(n=1,r,WR(w,c,WB(z,WL(y)),n-1))
    )
)

WORD MAZE.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK
1	Z	1	S	G	P	E	2	T	H	E	D	I	Z	B	A	N	T	S	N	S			defined names
2	S	P	?	A	K	I	W	K	1	F	H	V	Z	G	2	I	E	K	A	X			ar: A1:T15 (sample array)
3	?	I	T	Q	E	?	L	A	S	I	X	Q	J	N	S	X	4	T	J	K			rw: 15 (width is always 20)
4	L	E	N	J	F	X	A	4	T	I	K	N	S	B	X	1	D	J	C	P			cs: {-1,1,20,-20} (constant array for "snake" type lookup
5	G	D	L	3	3	D	M	V	L	T	G	K	?	C	U	3	O	Q	O	O			cd: {-21,-19,19,21} (constant array for "diagonal" type lookup
6	I	A	I	U	V	G	Y	L	U	?	I	E	P	3	W	G	K	B	T	P
7	4	A	P	A	U	4	C	Z	V	F	F	F	A	F	I	P	A	X	T	T			"snake" lookup						"diagonal" lookup
8	H	N	?	4	G	C	K	S	4	I	D	R	H	N	N	A	J	D	N	S
9	E	C	3	X	C	O	D	B	V	Q	O	Y	J	E	R	G	S	K	A	H			=WR("snake",cs)						=WR("diagonal",cd)
10	E	X	1	Z	?	P	N	I	3	O	W	C	C	N	2	U	R	E	G	J			3						82
11	E	O	N	M	E	V	K	A	B	E	P	F	L	Q	N	Z	?	E	W	3			18
12	K	A	N	?	A	I	B	K	L	G	2	4	?	N	?	Z	B	N	Q	E			20						=WR("advance",cd)
13	S	M	O	4	Y	F	B	B	R	E	?	D	N	E	1	A	D	J	M	4			160						67
14	C	F	X	4	3	T	Y	1	Z	J	N	I	W	U	Z	3	O	W	H	M			224
15	T	Y	D	2	Y	Z	S	U	D	V	V	F	4	O	Z	E	K	A	?	S			300
16
17	=SEQUENCE(rw,20)																						=WR("difficult",cs)
18	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20			151
19	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40
20	41	42	43	44	45	46	47	48	49	50	51	52	53	54	55	56	57	58	59	60			=WR("winner",cs)
21	61	62	63	64	65	66	67	68	69	70	71	72	73	74	75	76	77	78	79	80			115
22	81	82	83	84	85	86	87	88	89	90	91	92	93	94	95	96	97	98	99	100			273
23	101	102	103	104	105	106	107	108	109	110	111	112	113	114	115	116	117	118	119	120
24	121	122	123	124	125	126	127	128	129	130	131	132	133	134	135	136	137	138	139	140
25	141	142	143	144	145	146	147	148	149	150	151	152	153	154	155	156	157	158	159	160		Note: I left the results in "sequence numbers" representation on purpose,
26	161	162	163	164	165	166	167	168	169	170	171	172	173	174	175	176	177	178	179	180		to be much easier to visualize the results.
27	181	182	183	184	185	186	187	188	189	190	191	192	193	194	195	196	197	198	199	200		To get them to "range" representation we can use PR(a) (print results)
28	201	202	203	204	205	206	207	208	209	210	211	212	213	214	215	216	217	218	219	220		PR(a)=LAMBDA(a,LET(x,QUOTIENT(a-1,20)+1,y,MOD(a-1,20)+1,ADDRESS(x,y,4)))
29	221	222	223	224	225	226	227	228	229	230	231	232	233	234	235	236	237	238	239	240
30	241	242	243	244	245	246	247	248	249	250	251	252	253	254	255	256	257	258	259	260
31	261	262	263	264	265	266	267	268	269	270	271	272	273	274	275	276	277	278	279	280			C1						B5
32	281	282	283	284	285	286	287	288	289	290	291	292	293	294	295	296	297	298	299	300			R1
33																							T1						G4
34	Important Note: Covered here only snake and diagonal search, for being the more complicated ones.																						T8
35	Anyhow, to cover the rest of them the only thing we have to do is defining new constant arrays																						D12
36	cs (constant snake) {-1,1,20,-20}																						T15
37	cd (constant diagonal) {-21,-19,19,21}
38	For example, for horizontal lookup we have to define																						K8
39	ch {-1,1} and for vertical cv: {-20,20}
40																							O6
41																							M14
42
43
WM snake diagonal

Cell Formulas
Range	Formula
W9,W20,W17,A17,AC12,AC9	W9	=FORMULATEXT(W10)
W10:W15	W10	=WR("snake",cs)
AC10	AC10	=WR("diagonal",cd)
AC13	AC13	=WR("advance",cd)
A18:T32	A18	=SEQUENCE(rw,20)
W18	W18	=WR("difficult",cs)
W21:W22	W21	=WR("winner",cs)
W31:W36	W31	=PR(W10#)
AC31	AC31	=PR(AC10)
AC33,W38	AC33	=PR(AC13)
W40:W41	W40	=PR(W21#)
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
ar	='WM snake diagonal'!$A$1:$T$15	AC13, AC10, W21, W18, W10

 

[Xlambda]

With the new CF formula, everything is ok!
To double check, I've also made D3 "visible". (black "ink")
Attached, screen capture.

WORDLE function WordleHelperFromMrExcel.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Word					1	2	3	4	5					function waiting for "arguments"
2	aahed		spin	n									DV list		=WORDLE(A2:A8939,"bortchfusgd","ai",14,"illl",3452)
3	aalii			aalii	1	a	b	o	r	t			abort		aalii
4	aargh				2	c	h	i	l	e
5	abaca				3	f	u	s	i	l
6	abaci				4	a	l	g	i	d
7	aback				5	a	a	l	i	i
8	abaft				6						no word
9	abaka
10	abamp					Tactics
11	abase					Choose as 1st word a word that has no duplicate letters
12	abash				1	abort
13	abate					When we have a "green", exclude that letter on purpose
14	abaya					(since we already know where "a" is will use its
15	abbas					space for other letter)
16	abbes					1st argument:
17	abbey					(…"borta") and chose from results "chile"
18	abbot				2	chile
19	abeam					still keep "a" out
20	abele					2nd argument:
21	abets					(..."bortache",,,"il",34) and chose from results "fusil"
22	abhor				3	fusil
23	abide					now introduce all arguments correctly
24	abled					3rd argument:
25	abler					(..."bortchfus","ai",14,"ill",345) => only 4 words possible
26	ables
27	abmho			=WORDLE(A2:A8939,"bortchfus","ai",14,"ill",345)
28	abode			aalii
29	abohm			algid		chose "algid"
30	aboil			algin
31	aboma			alkie
32	aboon
33	abort				4	algid
34	about					4th argument:
35	above					(..."bortchfusgd","ai",14,"illl",3452)
36	abris
37	abuse			=WORDLE(A2:A8939,"bortchfusgd","ai",14,"illl",3452)
38	abuts			aalii
39	abuzz			final result!!!
40	abyes
My WORDLE

Cell Formulas
Range	Formula
O2,D37,D27	O2	=FORMULATEXT(O3)
D3	D3	=IF(D2="n",D3,INDEX(A2:A8939,RANDBETWEEN(1,8938)))
O3	O3	=WORDLE(A2:A8939,"bortchfusgd","ai",14,"illl",3452)
K3:K8	K3	=IF(ISNA(XMATCH(TEXTJOIN("",,F3:J3),$A$2:$A$8939)),"no word","")
D28:D31	D28	=WORDLE(A2:A8939,"bortchfus","ai",14,"ill",345)
D38	D38	=WORDLE(A2:A8939,"bortchfusgd","ai",14,"illl",3452)
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F3:J8	Expression	=F3=MID($D$3,F$1,1)	text	NO
F3:J8	Expression	=LET(x,SEARCH(F3,$D$3),AND(F3<>"",ISNUMBER(x),x<>F$1))	text	NO
F3:J8	Expression	=ISERR(SEARCH(F3,$D$3))	text	NO

Cells with Data Validation
Cell	Allow	Criteria
M3	List	=$A$2:$A$8939

 

[Xlambda]

This will be the last "disclosure" of a real WORDLE game.
Chose to share this one because I have used MrExcel tactics regarding the best word to start with.
Wordle Best Starting Words is AROSE not ADIEU - Episode 2463
On the other hand, based on same brilliant ideas, there is a tone of good material for designing formulas with the new helper functions.
Screen capture with statistic only, can be opened, does not show letters matrix.

WORDLE function WordleHelperFromMrExcel.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Word		SPOILER ALERT !!!!! This will reveal today's wordle.
2	aahed		¡¡¡ Scroll down only if you want to see the result !!!
3	aalii		Used MrExcel tactics for 1st word, that is able to eliminate
4	aargh		lot of words, or, match more letters.
5	abaca
6	abaci
7	aback
8	abaft
9	abaka
10	abamp
11	abase
12	abash
13	abate
14	abaya
15	abbas
16	abbes
17	abbey
18	abbot
19	abeam
20	abele
21	abets
22	abhor
23	abide
24	abled
25	abler
26	ables
27	abmho
28	abode
29	abohm
30	aboil
31	aboma
32	aboon
33	abort
34	about
35	above
36	abris
37	abuse
38	abuts
39	abuzz
40	abyes
41	abysm
42	abyss
43	acari
44	acerb								=WORDLE(A2:A8939,"rosebitmp","ha",23,"aahc",1251)
45	aceta		A	R	O	S	E		whack
46	ached		B	A	I	T	H
47	aches		C	H	A	M	P
48	achoo		W	H	A	C	K
49	acids
WORDLE 26Jan22

Cell Formulas
Range	Formula
I44	I44	=FORMULATEXT(I45)
I45	I45	=WORDLE(A2:A8939,"rosebitmp","ha",23,"aahc",1251)

 

[Xlambda]

To play indefinitely, no one/day restriction, no spoiler alert needed.
Wordle Game - Play Online
Wordle Game - Play WORDLE Unlimited

 

[Xlambda]

Checked both sites. Here are some examples.
Screen captures inserted. (proof that games were genuine).

WORDLE function WordleHelperFromMrExcel.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	Word
2	aahed		ex.1 wordlegame.org						=WORDLE(A2:A8939,"areinmkh","oscu",2534,"osc",341)
3	aalii		A	R	O	S	E		focus
4	aargh		C	O	I	N	S		locus
5	abaca		M	O	C	K	S
6	abaci		H	O	C	K	S
7	aback		F	O	C	U	S
8	abaft
9	abaka		ex.2 wordlegame.org									ex.3 wordlegame.org						ex.4 wordle-play.com
10	abamp		E	X	C	E	L					E	X	C	E	L		E	X	C	E	L
11	abase		A	D	I	O	S					A	D	O	B	E		A	L	I	E	N
12	abash		B	U	R	S	T					B	A	D	G	E
13	abate		S	K	I	L	L
14	abaya
15	abbas		for fun, started with "excel"									"excel" again						"excel again"
16	abbes		1st argument kept the green "l" out								=WORDLE(A2:A8939,"xclo","e",5,"adb",124)							(..."xc","e",4,"el",15) , chose "alien"
17	abbey		(..."excl") chose from results "adios"									badge						super lucky guess
18	abbot		2nd argument, kept the green "i" out also									barde
19	abeam		(..."excladoi",,,"s",5) chose "burst"
20	abele		3rd argument , followed correct patterns									Notes:
21	abets		(..."excadoburt","li",53,"ss",54)									There is a different CF approach between the 2 sites
22	abhor											For ex.4 "e" is both yellow and green but there is only one "e"
23	abide		=WORDLE(A2:A8939,"excadoburt","li",53,"ss",54)									For ex.3 "e" is both yellow and black=> is only one "e" for sure
24	abled		shill									If ex.4 would have happened with ex.3's CF, would have meant
25	abler		skill		chose "skill" , lucky guess							that are 2 "e"'s
26	ables		spill
27	abmho		swill									Even if we start with a word with dups, could be helpful
28	abode
29	abohm											Humble Conclusion:
30	aboil											Whatever rules we follow, solving wordle games with the
31	aboma											help of WORDLE function is, in my opinion, fun, but too easy.
32	aboon											Domestic use, for fun, is ok, engaged in a competition, wouldn’t be fair.
33	abort
wordle org

Cell Formulas
Range	Formula
I2,C23	I2	=FORMULATEXT(I3)
I3:I4	I3	=WORDLE(A2:A8939,"areinmkh","oscu",2534,"osc",341)
K16	K16	=FORMULATEXT(L17)
L17:L18	L17	=WORDLE(A2:A8939,"xclo","e",5,"adb",124)
C24:C27	C24	=WORDLE(A2:A8939,"excadoburt","li",53,"ss",54)
Dynamic array formulas.

 

[Xlambda]

Some lambda formulas "workout".
Letters distribution, 2 methods. Duplicate letters counted as one.
1st method. No UNIQUE, no MID functions.

WORDLE function WordleHelperFromMrExcel.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Word		Letters distribution all words (no dups) 1st method, no UNIQUE, no MID needed
2	aahed		Duplicate letters are counted as one
3	aalii									single cell formula P14
4	aargh		=CHAR(SEQUENCE(26,,97))							=LET(a,A2:A8939,l,CHAR(SEQUENCE(26,,97)),s,SEQUENCE(8938), r,REDUCE(0,s,LAMBDA(v,i, v+ISNUMBER(SEARCH(l,INDEX(a,i))))),SORT(IF({1,0},l,r),2,-1))
5	abaca		↓		only for 1st word in list
6	abaci		↓		SEARCH delivers for "a" first position only
7	aback		↓		=--(ISNUMBER(SEARCH(C8#,A2)))
8	abaft		a		1
9	abaka		b		0		summing all search arrays for each word in list
10	abamp		c		0		8938 iterations for all words in list with REDUCE
11	abase		d		1		=REDUCE(0,SEQUENCE(8938),LAMBDA(v,i,v+ISNUMBER(SEARCH(C8#,INDEX(A2:A8939,i)))))
12	abash		e		1		3620
13	abate		f		0		1023		joining			sorting descending order				single cell
14	abaya		g		0		1412		=IF({1,0},C8#,G12#)			=SORT(I15#,2,-1)				P14
15	abbas		h		1		1617		a	3620		s	4124			s	4124
16	abbes		i		0		3993		b	1023		e	3993			e	3993
17	abbey		j		0		708		c	1412		a	3620			a	3620
18	abbot		k		0		1052		d	1617		r	2753			r	2753
19	abeam		l		0		1188		e	3993		o	2632			o	2632
20	abele		m		0		2516		f	708		i	2516			i	2516
21	abets		n		0		184		g	1052		l	2231			l	2231
22	abhor		o		0		924		h	1188		t	2139			t	2139
23	abide		p		0		2231		i	2516		n	1922			n	1922
24	abled		q		0		1270		j	184		u	1657			u	1657
25	abler		r		0		1922		k	924		d	1617			d	1617
26	ables		s		0		2632		l	2231		c	1412			c	1412
27	abmho		t		0		1310		m	1270		y	1372			y	1372
28	abode		u		0		79		n	1922		p	1310			p	1310
29	abohm		v		0		2753		o	2632		m	1270			m	1270
30	aboil		w		0		4124		p	1310		h	1188			h	1188
31	aboma		x		0		2139		q	79		g	1052			g	1052
32	aboon		y		0		1657		r	2753		b	1023			b	1023
33	abort		z		0		465		s	4124		k	924			k	924
34	about						689		t	2139		f	708			f	708
35	above						209		u	1657		w	689			w	689
36	abris						1372		v	465		v	465			v	465
37	abuse						227		w	689		z	227			z	227
38	abuts								x	209		x	209			x	209
39	abuzz								y	1372		j	184			j	184
40	abyes								z	227		q	79			q	79
41	abysm
letters distribution 1

Cell Formulas
Range	Formula
C4	C4	=FORMULATEXT(C8)
E7,I14,L14,G11	E7	=FORMULATEXT(E8)
C8:C33	C8	=CHAR(SEQUENCE(26,,97))
E8:E33	E8	=--(ISNUMBER(SEARCH(C8#,A2)))
G12:G37	G12	=REDUCE(0,SEQUENCE(8938),LAMBDA(v,i,v+ISNUMBER(SEARCH(C8#,INDEX(A2:A8939,i)))))
I15:J40	I15	=IF({1,0},C8#,G12#)
L15:M40	L15	=SORT(I15#,2,-1)
P15:Q40	P15	=LET(a,A2:A8939,l,CHAR(SEQUENCE(26,,97)),s,SEQUENCE(8938),r,REDUCE(0,s,LAMBDA(v,i,v+ISNUMBER(SEARCH(l,INDEX(a,i))))),SORT(IF({1,0},l,r),2,-1))
Dynamic array formulas.

 

[Xlambda]

Letters distribution.
2nd method. using UNIQUE and MID, single cell formula

WORDLE function WordleHelperFromMrExcel.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	Word		Letters distribution all words (no dups) 2nd method, UNIQUE and MID												formula O9
2	aahed		Duplicate letters are counted as one												=LET(a,A2:A8939,l,CHAR(SEQUENCE(26)+96),s,SEQUENCE(,5), u,MID(BYROW(MID(a,s,1),LAMBDA(x,CONCAT(UNIQUE(x,1)))),s,1), d,BYROW(l,LAMBDA(x,SUM(--(x=u)))), SORT(IF({1,0},l,d),2,-1))
3	aalii		unique letters, each word
4	aargh		=BYROW(MID(A2:A8939,SEQUENCE(,5),1),LAMBDA(x,CONCAT(UNIQUE(x,1))))
5	abaca		ahed								=CHAR(SEQUENCE(26)+96)
6	abaci		ali		=MID(C5#,SEQUENCE(,5),1)								=BYROW(K7#,LAMBDA(x,SUM(--(x=E7#))))
7	aback		argh		a	h	e	d			a		3620		single cell
8	abaft		abc		a	l	i				b		1023		O9
9	abaka		abci		a	r	g	h			c		1412		s	4124
10	abamp		abck		a	b	c				d		1617		e	3993
11	abase		abft		a	b	c	i			e		3993		a	3620
12	abash		abk		a	b	c	k			f		708		r	2753
13	abate		abmp		a	b	f	t			g		1052		o	2632
14	abaya		abse		a	b	k				h		1188		i	2516
15	abbas		absh		a	b	m	p			i		2516		l	2231
16	abbes		abte		a	b	s	e			j		184		t	2139
17	abbey		aby		a	b	s	h			k		924		n	1922
18	abbot		abs		a	b	t	e			l		2231		u	1657
19	abeam		abes		a	b	y				m		1270		d	1617
20	abele		abey		a	b	s				n		1922		c	1412
21	abets		abot		a	b	e	s			o		2632		y	1372
22	abhor		abem		a	b	e	y			p		1310		p	1310
23	abide		abel		a	b	o	t			q		79		m	1270
24	abled		abets		a	b	e	m			r		2753		h	1188
25	abler		abhor		a	b	e	l			s		4124		g	1052
26	ables		abide		a	b	e	t	s		t		2139		b	1023
27	abmho		abled		a	b	h	o	r		u		1657		k	924
28	abode		abler		a	b	i	d	e		v		465		f	708
29	abohm		ables		a	b	l	e	d		w		689		w	689
30	aboil		abmho		a	b	l	e	r		x		209		v	465
31	aboma		abode		a	b	l	e	s		y		1372		z	227
32	aboon		abohm		a	b	m	h	o		z		227		x	209
33	abort		aboil		a	b	o	d	e						j	184
34	about		abom		a	b	o	h	m						q	79
35	above		abon		a	b	o	i	l
36	abris		abort		a	b	o	m
letters distribution 2

Cell Formulas
Range	Formula
C4,M6,E6	C4	=FORMULATEXT(C5)
C5:C8942	C5	=BYROW(MID(A2:A8939,SEQUENCE(,5),1),LAMBDA(x,CONCAT(UNIQUE(x,1))))
K5	K5	=FORMULATEXT(K7)
E7:I8944	E7	=MID(C5#,SEQUENCE(,5),1)
K7:K32	K7	=CHAR(SEQUENCE(26)+96)
M7:M32	M7	=BYROW(K7#,LAMBDA(x,SUM(--(x=E7#))))
O9:P34	O9	=LET(a,A2:A8939,l,CHAR(SEQUENCE(26)+96),s,SEQUENCE(,5),u,MID(BYROW(MID(a,s,1),LAMBDA(x,CONCAT(UNIQUE(x,1)))),s,1),d,BYROW(l,LAMBDA(x,SUM(--(x=u)))),SORT(IF({1,0},l,d),2,-1))
Dynamic array formulas.

 

[Xlambda]

Challenging task. Extract all existing anagrams of Words list, in descending order, 2D array.
Part 1.

WORDLE function WordleHelperFromMrExcel.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Word			defined name, word list A2:A8939=wl													Note: index nr. for words
2	aahed		D6:	=BYROW(MID(wl,SEQUENCE(,5),1),LAMBDA(x,CONCAT(SORT(x,,,1))))									step3.				with no anagrams in list
3	aalii			step1. sort letters of each word in ascending order					step 2. unique values, exactly once				identifying index nr.				=NOT(O6#)*SEQUENCE(8938)
4	aargh			all anagrams will be duplicates					all the rest will be anagrams				words that have anagrams
5	abaca			(expand,sort,join, for each row)					=UNIQUE(D6#,,1)				=XMATCH(D6#,I6#)		=ISNA(M6#)		=O6#*SEQUENCE(8938)
6	abaci			aadeh	b				aaiil	u			#N/A		TRUE	x	1
7	aback			aaiil		Note:			aaghr		nr. words		1		FALSE		0
8	abaft			aaghr		b,u,x			aaabc		appear only once		2		FALSE		0
9	abaka			aaabc		variabele names			aabci		=ROWS(I6#)		3		FALSE		0
10	abamp			aabci		in final formula			aabck		4928		4		FALSE		0
11	abase			aabck					aabft		out of		5		FALSE		0
12	abash			aabft					aaabk		8938		6		FALSE		0
13	abate			aaabk					aabmp		total words		7		FALSE		0
14	abaya			aabmp					aabes				8		FALSE		0
15	abbas			aabes					aabhs				9		FALSE		0
16	abbes			aabhs					aabet				10		FALSE		0
17	abbey			aabet					aaaby				11		FALSE		0
18	abbot			aaaby					abbey				12		FALSE		0
19	abeam			aabbs					abbot				#N/A		TRUE		14
20	abele			abbes					abeel				#N/A		TRUE		15
21	abets			abbey					abhor				13		FALSE		0
22	abhor			abbot					abdei				14		FALSE		0
23	abide			aabem					abilo				#N/A		TRUE		18
24	abled			abeel					aabmo				15		FALSE		0
25	abler			abest					abnoo				#N/A		TRUE		20
26	ables			abhor					abotu				16		FALSE		0
27	abmho			abdei					abeov				17		FALSE		0
28	abode			abdel					abuzz				#N/A		TRUE		23
29	abohm			abelr					abesy				#N/A		TRUE		24
30	aboil			abels					abmsy				#N/A		TRUE		25
31	aboma			abhmo					aacir				#N/A		TRUE		26
32	aboon			abdeo					aacet				#N/A		TRUE		27
33	abort			abhmo					acdeh				#N/A		TRUE		28
34	about			abilo					achoo				18		FALSE		0
35	above			aabmo					acdiy				19		FALSE		0
36	abris			abnoo					acgin				20		FALSE		0
37	abuse			abort					aciin				#N/A		TRUE		32
38	abuts			abotu					aceek				21		FALSE		0
39	abuzz			abeov					accim				22		FALSE		0
40	abyes			abirs					accko				#N/A		TRUE		35
41	abysm			abesu					acdlo				#N/A		TRUE		36
42	abyss			abstu					acetu				#N/A		TRUE		37
43	acari			abuzz					aadeg				23		FALSE		0
44	acerb			abesy					aadpt				24		FALSE		0
45	aceta			abmsy					aaddx				25		FALSE		0
46	ached			abssy					addde				#N/A		TRUE		41
47	aches			aacir					adeiu				26		FALSE		0
48	achoo			abcer					adios				#N/A		TRUE		43
49	acids			aacet					adimt				27		FALSE		0
50	acidy			acdeh					adimx				28		FALSE		0
51	acing			acehs					abdoo				#N/A		TRUE		46
Extracting anagrams 1

Cell Formulas
Range	Formula
D2	D2	=FORMULATEXT(D6)
I5,K9,M5,O5,Q5	I5	=FORMULATEXT(I6)
D6:D8943	D6	=BYROW(MID(wl,SEQUENCE(,5),1),LAMBDA(x,CONCAT(SORT(x,,,1))))
I6:I4933	I6	=UNIQUE(D6#,,1)
M6:M8943	M6	=XMATCH(D6#,I6#)
O6:O8943	O6	=ISNA(M6#)
Q6:Q8943	Q6	=O6#*SEQUENCE(8938)
K10	K10	=ROWS(I6#)
K12	K12	=ROWS(D6#)
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
wl	='Extracting anagrams 1'!$A$2:$A$8939	D6

 

[Xlambda]

WORDLE function WordleHelperFromMrExcel.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1	Word			Part2.						extracting horizontally, rows index numbers of matching anagrams
2	aahed									for a single row (first row). we have to write a formula that can spill horizontally
3	aalii			aadeh	b	aaiil	u	TRUE	x	=TRANSPOSE(FILTER(SEQUENCE(ROWS(wl)),D3=D3#))
4	aargh			aaiil		aaghr		FALSE		1	141	=>words of row 1 and row 141 are anagrams
5	abaca			aaghr		aaabc		FALSE		step4.
6	abaci			aaabc		aabci		FALSE		we need to do same calculations for all 8938 rows.
7	aback			aabci		aabck		FALSE		since BYROW can not spill horizontally, will use REDUCE with an accumulator "v" that
8	abaft			aabck		aabft		FALSE		builds the array row by row, appending the array "v" of (1,i-1) rows to current i row
9	abaka			aabft		aaabk		FALSE
10	abamp			aaabk		aabmp		FALSE		=REDUCE(0,SEQUENCE(8938),LAMBDA(v,i,IF(SEQUENCE(i)=i,LET(x,IF(INDEX(D3#,i)=D3#,SEQUENCE(8938),""),TRANSPOSE(FILTER(x,x<>""))),v)))
11	abase			aabmp		aabes		FALSE	d	1	141	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
12	abash			aabes		aabhs		FALSE		2	2	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A			rows of this color, that have same value
13	abate			aabhs		aabet		FALSE		3	3	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		horizontally, are like this because of the "appending" iteration
14	abaya			aabet		aaaby		FALSE		4	4	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		process, and corespond to the rows that have no anagrams.
15	abbas			aaaby		abbey		FALSE		5	5	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		All these rows will be filtered out anyhow.
16	abbes			aabbs		abbot		TRUE		6	6	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
17	abbey			abbes		abeel		TRUE		7	7	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
18	abbot			abbey		abhor		FALSE		8	8	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
19	abeam			abbot		abdei		FALSE		9	9	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
20	abele			aabem		abilo		TRUE		10	10	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
21	abets			abeel		aabmo		FALSE		11	11	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
22	abhor			abest		abnoo		TRUE		12	12	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
23	abide			abhor		abotu		FALSE		13	13	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
24	abled			abdei		abeov		FALSE		14	516	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
25	abler			abdel		abuzz		TRUE		15	518	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
26	ables			abelr		abesy		TRUE		16	16	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
27	abmho			abels		abmsy		TRUE		17	17	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
28	abode			abhmo		aacir		TRUE		18	244	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
29	abohm			abdeo		aacet		TRUE		19	19	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
30	aboil			abhmo		acdeh		TRUE		20	600	604	633	634	698	7612	#N/A	#N/A	#N/A	#N/A	#N/A
31	aboma			abilo		achoo		FALSE		21	21	21	21	21	21	21	#N/A	#N/A	#N/A	#N/A	#N/A
32	aboon			aabmo		acdiy		FALSE		22	22	22	22	22	22	22	#N/A	#N/A	#N/A	#N/A	#N/A
33	abort			abnoo		acgin		FALSE		23	546	785	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
34	about			abort		aciin		TRUE		24	547	793	802	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
35	above			abotu		aceek		FALSE		25	548	794	6532	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
36	abris			abeov		accim		FALSE		26	28	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
37	abuse			abirs		accko		TRUE		27	83	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
38	abuts			abesu		acdlo		TRUE		26	28	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
39	abuzz			abstu		acetu		TRUE		29	29	29	29	29	29	29	#N/A	#N/A	#N/A	#N/A	#N/A
40	abyes			abuzz		aadeg		FALSE		30	30	30	30	30	30	30	#N/A	#N/A	#N/A	#N/A	#N/A
41	abysm			abesy		aadpt		FALSE		31	31	31	31	31	31	31	#N/A	#N/A	#N/A	#N/A	#N/A
42	abyss			abmsy		aaddx		FALSE		32	851	7617	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
43	acari			abssy		addde		TRUE		33	33	33	33	33	33	33	#N/A	#N/A	#N/A	#N/A	#N/A
44	acerb			aacir		adeiu		FALSE		34	34	34	34	34	34	34	#N/A	#N/A	#N/A	#N/A	#N/A
45	aceta			abcer		adios		TRUE		35	6531	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
46	ached			aacet		adimt		FALSE		36	635	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
47	aches			acdeh		adimx		FALSE		37	7619	8091	8094	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
48	achoo			acehs		abdoo		TRUE		38	38	38	38	38	38	38	#N/A	#N/A	#N/A	#N/A	#N/A
49	acids			achoo		adopt		FALSE		39	39	39	39	39	39	39	#N/A	#N/A	#N/A	#N/A	#N/A
50	acidy			acdis		adnow		TRUE		40	40	40	40	40	40	40	#N/A	#N/A	#N/A	#N/A	#N/A
51	acing			acdiy		adeoz		FALSE		41	599	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
52	acini			acgin		adltu		FALSE		42	42	42	42	42	42	42	#N/A	#N/A	#N/A	#N/A	#N/A
53	ackee			aciin		acdnu		FALSE		43	958	1137	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
Extracting anagrams 2

Cell Formulas
Range	Formula
D3:D8940	D3	=BYROW(MID(wl,SEQUENCE(,5),1),LAMBDA(x,CONCAT(SORT(x,,,1))))
F3:F4930	F3	=UNIQUE(D3#,,1)
H3:H8940	H3	=ISNA(XMATCH(D3#,F3#))
J3,J10	J3	=FORMULATEXT(J4)
J4:K4	J4	=TRANSPOSE(FILTER(SEQUENCE(ROWS(wl)),D3=D3#))
J11:U8948	J11	=REDUCE(0,SEQUENCE(8938),LAMBDA(v,i,IF(SEQUENCE(i)=i,LET(x,IF(INDEX(D3#,i)=D3#,SEQUENCE(8938),""),TRANSPOSE(FILTER(x,x<>""))),v)))
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
'Extracting anagrams 2'!wl	='Extracting anagrams 2'!$A$2:$A$8939	J4, D3

 

[Xlambda]

WORDLE function WordleHelperFromMrExcel.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI
1	Word			Part3.																			step5. extracting the anagram words: index(wl,unique(filter(d,x)))
2	aahed
3	aalii																						=IFERROR(INDEX(wl,UNIQUE(FILTER(J4#,H4#))),"")
4	aargh			aadeh	b	aaiil	u	TRUE	x	1	141	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	d	aahed	ahead											e
5	abaca			aaiil		aaghr		FALSE		2	2	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		abbas	babas
6	abaci			aaghr		aaabc		FALSE		3	3	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		abbes	babes
7	aback			aaabc		aabci		FALSE		4	4	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		abeam	ameba
8	abaft			aabci		aabck		FALSE		5	5	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		abets	baste	bates	beast	beats	betas	tabes
9	abaka			aabck		aabft		FALSE		6	6	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		abled	baled	blade
10	abamp			aabft		aaabk		FALSE		7	7	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		abler	baler	blare	blear
11	abase			aaabk		aabmp		FALSE		8	8	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		ables	bales	blase	sable
12	abash			aabmp		aabes		FALSE		9	9	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		abmho	abohm
13	abate			aabes		aabhs		FALSE		10	10	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		abode	adobe
14	abaya			aabhs		aabet		FALSE		11	11	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		abort	boart	tabor
15	abbas			aabet		aaaby		FALSE		12	12	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		abris	sabir
16	abbes			aaaby		abbey		FALSE		13	13	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		abuse	beaus
17	abbey			aabbs		abbot		TRUE		14	516	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		abuts	tabus	tsuba	tubas
18	abbot			abbes		abeel		TRUE		15	518	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		abyss	bassy
19	abeam			abbey		abhor		FALSE		16	16	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		acerb	brace	caber
20	abele			abbot		abdei		FALSE		17	17	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		aches	chase
21	abets			aabem		abilo		TRUE		18	244	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		acids	asdic	cadis	caids
22	abhor			abeel		aabmo		FALSE		19	19	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		acmes	cames	maces
23	abide			abest		abnoo		TRUE		20	600	604	633	634	698	7612	#N/A	#N/A	#N/A	#N/A	#N/A		acned	caned	dance
24	abled			abhor		abotu		FALSE		21	21	21	21	21	21	21	#N/A	#N/A	#N/A	#N/A	#N/A		acnes	canes	scena
25	abler			abdei		abeov		FALSE		22	22	22	22	22	22	22	#N/A	#N/A	#N/A	#N/A	#N/A		acorn	narco	racon
26	ables			abdel		abuzz		TRUE		23	546	785	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		acred	arced	cadre	cared	cedar	raced
27	abmho			abelr		abesy		TRUE		24	547	793	802	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		acres	cares	carse	escar	races	scare	serac
28	abode			abels		abmsy		TRUE		25	548	794	6532	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		acrid	caird	daric
29	abohm			abhmo		aacir		TRUE		26	28	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		acted	cadet
30	aboil			abdeo		aacet		TRUE		27	83	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		actin	antic
31	aboma			abhmo		acdeh		TRUE		26	28	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		actor	taroc
32	aboon			abilo		achoo		FALSE		29	29	29	29	29	29	29	#N/A	#N/A	#N/A	#N/A	#N/A		acyls	clays	scaly
33	abort			aabmo		acdiy		FALSE		30	30	30	30	30	30	30	#N/A	#N/A	#N/A	#N/A	#N/A		adder	dared	dread	readd
34	about			abnoo		acgin		FALSE		31	31	31	31	31	31	31	#N/A	#N/A	#N/A	#N/A	#N/A		addle	dedal	laded
35	above			abort		aciin		TRUE		32	851	7617	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		adeem	edema
36	abris			abotu		aceek		FALSE		33	33	33	33	33	33	33	#N/A	#N/A	#N/A	#N/A	#N/A		adept	pated	taped
37	abuse			abeov		accim		FALSE		34	34	34	34	34	34	34	#N/A	#N/A	#N/A	#N/A	#N/A		adits	ditas	staid	tsadi
38	abuts			abirs		accko		TRUE		35	6531	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		adman	daman
39	abuzz			abesu		acdlo		TRUE		36	635	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		admen	amend	maned	menad	named
40	abyes			abstu		acetu		TRUE		37	7619	8091	8094	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		adore	oared	oread
41	abysm			abuzz		aadeg		FALSE		38	38	38	38	38	38	38	#N/A	#N/A	#N/A	#N/A	#N/A		adorn	andro	radon
42	abyss			abesy		aadpt		FALSE		39	39	39	39	39	39	39	#N/A	#N/A	#N/A	#N/A	#N/A		adust	dauts
43	acari			abmsy		aaddx		FALSE		40	40	40	40	40	40	40	#N/A	#N/A	#N/A	#N/A	#N/A		adzed	dazed
44	acerb			abssy		addde		TRUE		41	599	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		adzes	dazes
45	aceta			aacir		adeiu		FALSE		42	42	42	42	42	42	42	#N/A	#N/A	#N/A	#N/A	#N/A		aedes	eased
46	ached			abcer		adios		TRUE		43	958	1137	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		afire	feria
47	aches			aacet		adimt		FALSE		44	44	44	44	44	44	44	#N/A	#N/A	#N/A	#N/A	#N/A		agars	ragas
48	achoo			acdeh		adimx		FALSE		45	45	45	45	45	45	45	#N/A	#N/A	#N/A	#N/A	#N/A		agers	gears	rages	sager	sarge
49	acids			acehs		abdoo		TRUE		46	1315	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A		agger	eggar	gager
50	acidy			achoo		adopt		FALSE		47	47	47	47	47	47	47	#N/A	#N/A	#N/A	#N/A	#N/A		agism	sigma
Extracting anagrams 3

Cell Formulas
Range	Formula
W3	W3	=FORMULATEXT(W4)
D4:D8941	D4	=BYROW(MID(wl,SEQUENCE(,5),1),LAMBDA(x,CONCAT(SORT(x,,,1))))
F4:F4931	F4	=UNIQUE(D4#,,1)
H4:H8941	H4	=ISNA(XMATCH(D4#,F4#))
J4:U8941	J4	=REDUCE(0,SEQUENCE(8938),LAMBDA(v,i,IF(SEQUENCE(i)=i,LET(x,IF(INDEX(D4#,i)=D4#,SEQUENCE(8938),""),TRANSPOSE(FILTER(x,x<>""))),v)))
W4:AH1570	W4	=IFERROR(INDEX(wl,UNIQUE(FILTER(J4#,H4#))),"")
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
'Extracting anagrams 3'!wl	='Extracting anagrams 3'!$A$2:$A$8939	W4, D4

 

[Xlambda]

WORDLE function WordleHelperFromMrExcel.xlsx
	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX
1		Part4.													step6. array "d" in descending order of nr.anagrams/row
2		step5. extracting the anagram words: index(wl,unique(filter(d,x)))													=BYROW(W4#,LAMBDA(x,COUNTA(FILTER(x,x<>""))))
3		=IFERROR(INDEX(wl,UNIQUE(FILTER(J4#,H4#))),"")													↓		=INDEX(W4#,SORTBY(SEQUENCE(ROWS(W4#)),AJ4#,-1),SEQUENCE(,COLUMNS(W4#)))
4	d	aahed	ahead											e	2		apers	apres	asper	pares	parse	pears	prase	presa	rapes	reaps	spare	spear	final
5		abbas	babas												2		least	setal	slate	stale	steal	stela	taels	tales	teals	tesla			result
6		abbes	babes												2		arles	earls	lares	laser	lears	rales	reals	seral
7		abeam	ameba												2		lapse	leaps	pales	peals	pleas	salep	sepal	spale
8		abets	baste	bates	beast	beats	betas	tabes							7		peris	piers	pries	prise	ripes	speir	spier	spire
9		abled	baled	blade											3		abets	baste	bates	beast	beats	betas	tabes
10		abler	baler	blare	blear										4		acres	cares	carse	escar	races	scare	serac
11		ables	bales	blase	sable										4		amens	manes	manse	means	mensa	names	nemas
12		abmho	abohm												2		arils	lairs	laris	liars	liras	rails	rials
13		abode	adobe												2		aspen	napes	neaps	panes	peans	sneap	spean
14		abort	boart	tabor											3		caret	carte	cater	crate	react	recta	trace
15		abris	sabir												2		deist	diets	dites	edits	sited	stied	tides
16		abuse	beaus												2		diols	idols	lidos	loids	sloid	soldi	solid
17		abuts	tabus	tsuba	tubas										4		doers	doser	redos	resod	rodes	rosed	sored
18		abyss	bassy												2		emits	items	metis	mites	smite	stime	times
19		acerb	brace	caber											3		ester	reest	reset	steer	stere	terse	trees
20		aches	chase												2		laves	salve	selva	slave	vales	valse	veals
21		acids	asdic	cadis	caids										4		leapt	lepta	palet	petal	plate	pleat	tepal
22		acmes	cames	maces											3		paste	pates	peats	septa	spate	tapes	tepas
23		acned	caned	dance											3		peers	peres	perse	prees	prese	speer	spree
24		acnes	canes	scena											3		resaw	sawer	sewar	sware	swear	wares	wears
25		acorn	narco	racon											3		acred	arced	cadre	cared	cedar	raced
26		acred	arced	cadre	cared	cedar	raced								6		airts	astir	sitar	stair	stria	tarsi
27		acres	cares	carse	escar	races	scare	serac							7		albas	baals	balas	balsa	basal	sabal
28		acrid	caird	daric											3		alert	alter	artel	later	ratel	taler
29		acted	cadet												2		ardeb	barde	bared	beard	bread	debar
30		actin	antic												2		ashed	deash	hades	heads	sadhe	shade
31		actor	taroc												2		aster	rates	resat	stare	tares	tears
32		acyls	clays	scaly											3		bares	baser	bears	braes	saber	sabre
33		adder	dared	dread	readd										4		cruet	curet	cuter	eruct	recut	truce
34		addle	dedal	laded											3		dater	derat	rated	tared	trade	tread
35		adeem	edema												2		deers	drees	redes	reeds	seder	sered
36		adept	pated	taped											3		deils	delis	idles	isled	sidle	slide
37		adits	ditas	staid	tsadi										4		gater	grate	great	retag	targe	terga
38		adman	daman												2		hales	heals	leash	selah	shale	sheal
39		admen	amend	maned	menad	named									5		heros	hoers	horse	hoser	shoer	shore
40		adore	oared	oread											3		inset	neist	nites	senti	stein	tines
41		adorn	andro	radon											3		leets	sleet	steel	stele	teels	teles
42		adust	dauts												2		manos	mason	moans	monas	nomas	soman
43		adzed	dazed												2		mates	meats	satem	steam	tames	teams
44		adzes	dazes												2		notes	onset	seton	steno	stone	tones
45		aedes	eased												2		parts	prats	sprat	strap	tarps	traps
46		afire	feria												2		piles	plies	slipe	speil	spiel	spile
47		agars	ragas												2		pores	poser	prose	repos	ropes	spore
48		agers	gears	rages	sager	sarge									5		ratos	roast	rotas	sorta	taros	toras
49		agger	eggar	gager											3		reins	resin	rinse	risen	serin	siren
50		agism	sigma												2		riots	rotis	tiros	torsi	trios	trois
Extracting anagrams 3

Cell Formulas
Range	Formula
AJ2	AJ2	=FORMULATEXT(AJ4)
W3,AL3	W3	=FORMULATEXT(W4)
W4:AH1570	W4	=IFERROR(INDEX(wl,UNIQUE(FILTER(J4#,H4#))),"")
AJ4:AJ1570	AJ4	=BYROW(W4#,LAMBDA(x,COUNTA(FILTER(x,x<>""))))
AL4:AW1570	AL4	=INDEX(W4#,SORTBY(SEQUENCE(ROWS(W4#)),AJ4#,-1),SEQUENCE(,COLUMNS(W4#)))
Dynamic array formulas.

Named Ranges
Name	Refers To	Cells
'Extracting anagrams 3'!wl	='Extracting anagrams 3'!$A$2:$A$8939	W4