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

Here are the results of your fuzzy-string dictionary search for “tilth” 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.

75 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
tilth	8	55	1536	(None)
filth	11	50	1582	1	filth
tilt	4	62	5243	1	tilt_
tilths	9	45	937	1	tilths
tilts	5	53	2561	1	tilts
airth	8	56	2102	2	airth
atilt	5	48	2847	2	atilt_
birth	10	56	1987	2	birth
fifth	14	52	1092	2	fifth
filch	13	48	1332	2	filch
filths	12	38	978	2	filths
filthy	15	35	642	2	filthy
firth	11	58	1953	2	firth
gilt	5	63	4855	2	gilt_
gilts	6	49	2426	2	gilts
girth	9	56	1884	2	girth
hilt	7	58	5072	2	hilt_
hilts	8	69	2441	2	hilts
jilt	11	58	3943	2	jilt_
jilts	12	47	1741	2	jilts
kilt	8	61	4443	2	kilt_
kilts	9	51	2219	2	kilts
kilty	12	52	1390	2	kilty
kith	11	58	2637	2	ki_th
lilt	4	63	4995	2	lilt_
lilts	5	58	2280	2	lilts
milch	12	44	1337	2	milch
milt	6	54	5582	2	milt_
milts	7	54	3071	2	milts
milty	10	47	2007	2	milty
mirth	10	64	1889	2	mirth
ninth	8	3	1458	2	ninth
pith	9	54	3270	2	pi_th
silt	4	65	5820	2	silt_
silts	5	53	3082	2	silts
silty	8	47	2163	2	silty
sith	7	54	3516	2	si_th
sixth	15	55	1223	2	sixth
spilth	11	46	973	2	spilth
stilt	5	48	3198	2	stilt_
stilts	6	79	1531	2	stilts
teeth	8	73	1585	2	teeth
tenth	8	54	2183	2	tenth
teth	7	63	2789	2	t_eth
tight	9	36	2650	2	tight
til	3	63	5027	2	til__
tilak	9	10	1155	2	tilak
tilde	6	50	1735	2	tilde
tile	4	54	5145	2	til_e
tiled	6	48	3294	2	tiled
tiler	5	61	3102	2	tiler
tiles	5	55	4210	2	tiles
till	4	59	4121	2	til_l
tills	5	46	3171	2	tills
tils	4	57	3962	2	til_s
tilted	7	46	1686	2	tilted
tilter	6	34	1769	2	tilter
tint	4	67	5887	2	tint_
tints	5	60	3092	2	tints
tit	3	67	7106	2	ti_t_
tithe	8	53	1970	2	ti_the
titi	4	71	3063	2	ti_ti
title	5	47	2107	2	title
tits	4	61	4505	2	ti_ts
titty	8	53	1665	2	titty
tooth	8	80	2018	2	tooth
trilith	10	3	1051	2	trilith
troth	8	56	2220	2	troth
truth	8	52	1415	2	truth
width	12	3	1097	2	width
wilt	7	62	4630	2	wilt_
wilts	8	50	2350	2	wilts
with	10	57	3048	2	wi_th
yirth	11	65	1375	2	yirth
zilch	19	43	812	2	zilch

Search took 3 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.310	576422.6
2	DLD Change Limit	53800	75	1.796	29955.5
3	Display Results	75	75	0.033	2272.7
	(SQL Overall)	178691	75	2.139	83539.5