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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

103 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
lummox	17	3	305	(None)
flummox	21	4	141	1	flummox
lummoxes	19	4	255	2	lummoxes
summon	10	3	762	2	summon
ammo	8	55	2013	3	_ammo_
ammos	9	48	1582	3	_ammos
bummed	13	42	1172	3	bummed
bummer	12	40	1410	3	bummer
commix	19	40	776	3	commix
common	12	3	1080	3	common
cummer	12	44	1459	3	cummer
cummin	12	8	878	3	cummin
dumbo	10	56	1406	3	dumbo_
dumbos	11	41	1108	3	dumbos
dummy	13	47	1278	3	dumm_y
duomo	8	3	975	3	duomo_
duomos	9	3	682	3	duomos
flummoxed	24	4	89	3	flummoxed
flummoxes	23	5	150	3	flummoxes
gammon	11	3	890	3	gammon
glummer	12	41	798	3	glummer
gumbo	10	44	1358	3	gumbo_
gumbos	11	46	1087	3	gumbos
gumma	10	53	1310	3	gumm_a
gummas	11	48	1051	3	gummas
gummed	12	38	1166	3	gummed
gummer	11	46	1545	3	gummer
gummose	12	3	533	3	gummose
gummous	12	3	626	3	gummous
gummy	13	54	1365	3	gumm_y
hommos	13	12	850	3	hommos
hummed	14	48	1267	3	hummed
hummer	13	36	1527	3	hummer
hummock	20	6	379	3	hummock
hummus	13	3	624	3	hummus
humor	10	11	1051	3	hu_mor
immix	16	3	503	3	_immix
jumbo	16	43	1107	3	jumbo_
jumbos	17	37	912	3	jumbos
kummel	14	26	617	3	kummel
lammed	11	39	1562	3	lammed
lemma	9	48	1103	3	lemm_a
lemmas	10	34	916	3	lemmas
lemon	7	56	1818	3	l_emon
limbo	9	56	1481	3	limbo_
limbos	10	47	1214	3	limbos
limmer	10	43	1479	3	limmer
limo	6	55	2973	3	l_imo_
limos	7	53	2081	3	l_imos
lox	10	82	4096	3	l___ox
lum	5	55	4293	3	lu_m__
luma	6	55	2752	3	lu_m_a
lumas	7	56	2291	3	lu_mas
lumbar	10	36	1059	3	lumbar
lumber	10	38	1777	3	lumber
lumen	7	52	2090	3	lu_men
lumens	8	50	1397	3	lumens
lumina	8	46	1354	3	lumina
lump	8	65	3170	3	lu_m_p
lumped	11	42	1696	3	lumped
lumpen	10	40	1066	3	lumpen
lumper	10	38	1665	3	lumper
lumps	9	56	2498	3	lu_mps
lumpy	12	66	1591	3	lu_mpy
lums	6	57	3424	3	lu_m_s
lurex	12	48	1673	3	lu_rex
lux	10	65	2877	3	lu___x
mammon	9	3	964	3	mammon
mumm	7	57	1886	3	mumm__
mummed	10	44	1155	3	mummed
mummer	9	36	1454	3	mummer
mumms	8	55	1315	3	mumm_s
mummy	11	49	1362	3	mumm_y
muskox	19	3	395	3	muskox
outbox	15	3	746	3	outbox
outfox	16	3	614	3	outfox
plummer	13	29	852	3	plummer
plummet	13	27	835	3	plummet
plummy	15	37	566	3	plumm_y
pummel	12	27	804	3	pummel
rummer	10	47	1548	3	rummer
rummy	12	42	1241	3	rumm_y
rumor	7	10	1132	3	ru_mor
slummed	12	35	927	3	slummed
slummer	11	37	1120	3	slummer
slummy	13	32	586	3	slumm_y
summa	9	47	1331	3	summ_a
summae	10	39	1101	3	summae
summas	10	43	1316	3	summas
summed	11	40	1404	3	summed
summer	10	40	1771	3	summer
summit	10	3	1154	3	summit
summons	11	5	800	3	summons
sumo	6	73	2631	3	su_mo_
sumos	7	57	2009	3	su_mos
tummy	12	47	1199	3	tumm_y
tumor	7	11	1069	3	tu_mor
umbo	8	55	1666	3	_umbo_
umbos	9	46	1307	3	_umbos
umm	7	119	2126	3	_umm__
unbox	14	3	875	3	_unbox
unmix	14	38	897	3	_unmix
yummy	15	42	915	3	yumm_y

Search took 6 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	112716	0.376	475242.0
2	DLD Change Limit	112716	103	5.186	21734.7
3	Display Results	103	103	0.046	2239.1
	(SQL Overall)	178691	103	5.608	31863.6