Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “growthy” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

97 similar words found! Changes to Transform each Found Word to your word are shown as:
~~remove a letter~~ ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
growthy	17	7	328	(None)
growth	13	7	738	1	growth_
growths	14	9	442	1	growths
brothy	14	51	962	2	bro_thy
drouthy	14	39	517	2	drouthy
frothy	15	57	837	2	fro_thy
grotty	10	38	983	2	gro_tty
grouchy	16	29	424	2	grouchy
grouty	10	47	1098	2	grout_y
growly	13	49	917	2	grow_ly
rowth	11	57	1323	2	_rowth_
rowths	12	45	817	2	_rowths
trowth	12	7	788	2	trowth_
trowths	13	6	502	2	trowths
bothy	13	67	1396	3	_bo_thy
breathy	15	32	803	3	breathy
broth	10	65	2109	3	bro_th_
broths	11	50	1392	3	bro_ths
browny	14	45	1004	3	brow_ny
crowdy	15	46	717	3	crow_dy
crwth	13	3	748	3	cr_wth_
crwths	14	3	343	3	cr_wths
drouth	10	44	1010	3	drouth_
drouths	11	43	648	3	drouths
drowsy	13	48	790	3	drow_sy
forwhy	18	3	442	3	forw_hy
frosty	12	47	1063	3	frost_y
froth	11	59	1928	3	fro_th_
froths	12	54	1144	3	fro_ths
frowsty	16	46	498	3	frowsty
frowsy	15	49	827	3	frow_sy
frowzy	24	48	579	3	frow_zy
ghostly	14	35	510	3	ghostly
ghosty	13	46	721	3	ghost_y
glowfly	17	4	267	3	glowfly
goth	8	68	2508	3	g_o_th_
goths	9	65	1300	3	g_o_ths
gouty	9	52	1736	3	g_out_y
gowany	13	45	749	3	g_owany
greatly	11	3	761	3	greatly
gristly	11	18	733	3	gristly
grith	9	55	2037	3	gr_ith_
griths	10	52	1165	3	gr_iths
gritty	10	33	840	3	gr_itty
groat	6	55	3197	3	groat__
groats	7	48	1665	3	groat_s
grocery	13	33	676	3	grocery
grody	10	34	1206	3	gro__dy
groggy	12	3	480	3	gro_ggy
groovy	13	37	540	3	gro_ovy
grossly	11	7	598	3	grossly
groszy	19	39	570	3	gro_szy
grot	5	59	4205	3	gro_t__
grots	6	50	2585	3	gro_t_s
grotto	7	34	981	3	gro_tto
grottos	8	33	733	3	grottos
grouch	12	31	847	3	grouch_
grout	6	53	3042	3	grout__
grouted	9	41	1150	3	grouted
grouter	8	44	1252	3	grouter
grouts	7	50	1561	3	grout_s
grow	8	61	2730	3	grow___
grower	10	46	1493	3	grow_er
growers	11	36	1272	3	growers
growing	12	35	1247	3	growing
growl	9	61	1582	3	grow__l
growled	12	27	817	3	growled
growler	11	31	897	3	growler
growls	10	47	1111	3	grow_ls
grown	9	53	1735	3	grow__n
grownup	13	4	221	3	grownup
grows	9	55	2392	3	grow__s
growthier	16	4	220	3	growthier
grumphy	18	44	362	3	grumphy
ingrowth	15	5	302	3	ingrowth_
ingrowths	16	4	192	3	ingrowths
mothy	13	62	1455	3	_mo_thy
mouthy	14	40	906	3	_mouthy
regrowth	15	4	403	3	regrowth_
regrowths	16	4	243	3	regrowths
rooty	8	64	2302	3	_root_y
roughy	13	70	1085	3	_roughy
routh	8	64	2307	3	_routh_
rouths	9	54	1682	3	_rouths
rowdy	12	57	1153	3	_row_dy
smoothy	15	20	508	3	smoothy
toothy	12	52	969	3	_toothy
trophy	14	3	828	3	tro_phy
troth	8	56	2220	3	tro_th_
troths	9	54	1415	3	tro_ths
trouty	9	52	1179	3	trout_y
upgrowth	17	4	195	3	upgrowth_
upgrowths	18	5	133	3	upgrowths
worthy	15	59	880	3	_worthy
wrathy	15	37	785	3	wr_athy
wreathy	16	32	606	3	wreathy
wroth	11	68	1588	3	wro_th_

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	134027	0.406	440125.6
2	DLD Change Limit	134027	97	5.673	23625.4
3	Display Results	97	97	0.030	3233.3
	(SQL Overall)	178691	97	6.109	29250.5