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

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

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.

64 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
rowth	11	57	1323	(None)
growth	13	7	738	1	growth
routh	8	64	2307	1	routh
rowths	12	45	817	1	rowths
trowth	12	7	788	1	trowth
booth	10	55	2201	2	booth
both	9	65	3343	2	bo_th
broth	10	65	2109	2	bro_th
couth	10	61	2249	2	couth
crwth	13	3	748	2	crwth
doeth	9	4	1198	2	doeth
doth	8	62	2571	2	do_th
drouth	10	44	1010	2	drouth
forth	11	62	2267	2	forth
froth	11	59	1928	2	fro_th
goth	8	68	2508	2	go_th
growths	14	9	442	2	growths
growthy	17	7	328	2	growthy
loath	8	49	1860	2	loath
loth	7	61	3213	2	lo_th
month	10	48	1842	2	month
moth	9	67	3133	2	mo_th
mouth	10	54	2029	2	mouth
north	8	60	1827	2	north
nowt	7	88	3375	2	nowt_
nowts	8	69	1586	2	nowts
oath	7	61	3215	2	_oath
rath	7	60	3766	2	r_ath
roach	10	57	1700	2	roach
root	4	56	5592	2	root_
roots	5	59	3367	2	roots
rooty	8	64	2302	2	rooty
rot	3	72	8295	2	ro_t_
rota	4	58	3434	2	ro_ta
rotch	10	58	1593	2	rotch
rote	4	62	4902	2	ro_te
roti	4	63	3293	2	ro_ti
rotl	4	50	2968	2	ro_tl
roto	4	59	3505	2	ro_to
rots	4	64	5409	2	ro_ts
rotte	5	46	2593	2	rotte
rough	9	78	1943	2	rough
rout	4	61	5328	2	rout_
route	5	51	3207	2	route
rouths	9	54	1682	2	rouths
routs	5	71	3341	2	routs
row	6	74	5367	2	row__
rowan	8	54	1873	2	rowan
rowdy	12	57	1153	2	rowdy
rowed	9	40	3432	2	rowed
rowel	8	47	2141	2	rowel
rowen	8	49	2115	2	rowen
rower	8	54	3049	2	rower
rows	7	59	4175	2	row_s
ruth	7	68	2599	2	r_uth
sooth	8	59	2406	2	sooth
soth	7	59	3252	2	so_th
south	8	52	2357	2	south
tooth	8	80	2018	2	tooth
troth	8	56	2220	2	tro_th
trowths	13	6	502	2	trowths
worth	11	71	2052	2	worth
wroth	11	68	1588	2	wro_th
youth	11	53	1504	2	youth

Search took 2 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	53800	0.296	603685.8
2	DLD Change Limit	53800	64	1.656	32487.9
3	Display Results	64	64	0.016	4000.0
	(SQL Overall)	178691	64	1.968	90798.3