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

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

84 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
mothy	13	62	1455	(None)
bothy	13	67	1396	1	bothy
motey	10	59	2295	1	motey
moth	9	67	3133	1	moth_
moths	10	60	2155	1	moths
mouthy	14	40	906	1	mouthy
mythy	16	56	867	1	mythy
botchy	16	53	782	2	botchy
both	9	65	3343	2	both_
brothy	14	51	962	2	brothy
doth	8	62	2571	2	doth_
dotty	9	45	1610	2	dotty
doty	8	61	2822	2	dot_y
frothy	15	57	837	2	frothy
goth	8	68	2508	2	goth_
goths	9	65	1300	2	goths
hotly	11	58	1548	2	hotly
jotty	15	50	1260	2	jotty
lathy	11	52	1506	2	lathy
loth	7	61	3213	2	loth_
mashy	13	60	1650	2	mashy
matey	10	70	2266	2	matey
math	9	54	3745	2	math_
maths	10	56	2402	2	maths
meshy	13	56	1278	2	meshy
meth	9	58	2784	2	meth_
meths	10	53	2023	2	meths
methyl	14	3	640	2	methyl
mity	9	55	2821	2	mit_y
mocha	12	4	992	2	mocha
moggy	12	52	1216	2	moggy
moldy	11	50	1465	2	moldy
molly	10	52	2249	2	molly
moly	9	60	3191	2	mo_ly
mommy	11	40	1075	2	mommy
money	10	48	2684	2	money
month	10	48	1842	2	month_
monthly	15	3	567	2	monthly
months	11	38	1293	2	months
mony	9	68	3001	2	mo_ny
moody	11	50	1749	2	moody
moony	10	48	1827	2	moony
moory	10	51	1579	2	moory
mopey	12	48	2182	2	mopey
mopy	11	57	2197	2	mo_py
moray	10	54	2379	2	moray
mosey	10	59	2287	2	mosey
mosh	9	52	2760	2	mosh_
mossy	10	52	1706	2	mossy
mostly	11	31	1094	2	mostly
mot	5	72	7942	2	mot__
mote	6	70	4808	2	mot_e
motel	7	66	2324	2	motel
motes	7	59	4400	2	motes
motet	7	56	4119	2	motet
mother	11	37	1864	2	mother
mothery	15	37	1051	2	mothery
motif	10	5	1968	2	motif
motley	11	3	938	2	motley
motor	7	53	1729	2	motor
mots	6	68	5316	2	mot_s
mott	6	66	4844	2	mot_t
motte	7	55	2697	2	motte
motto	7	61	1951	2	motto
motts	7	65	2700	2	motts
mousy	10	67	1694	2	mousy
mouth	10	54	2029	2	mouth_
mouths	11	52	1453	2	mouths
mushy	13	53	1663	2	mushy
myth	12	67	1543	2	myth_
myths	13	59	1160	2	myths
pithy	13	56	1446	2	pithy
potsy	10	58	1561	2	potsy
potty	10	56	2100	2	potty
smithy	14	50	827	2	smithy
smoothy	15	20	508	2	smoothy
sophy	13	66	1176	2	sophy
soth	7	59	3252	2	soth_
soths	8	62	1863	2	soths
thy	9	70	2291	2	__thy
timothy	15	4	323	2	timothy
toothy	12	52	969	2	toothy
withy	14	48	1376	2	withy
worthy	15	59	880	2	worthy

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.313	570897.8
2	DLD Change Limit	53800	84	1.576	34137.1
3	Display Results	84	84	0.033	2545.5
	(SQL Overall)	178691	84	1.922	92971.4