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

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

87 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
mumped	13	38	1316	(None)
bumped	13	44	1400	1	bumped
dumped	12	38	1449	1	dumped
humped	14	40	1524	1	humped
jumped	18	35	1155	1	jumped
lumped	11	42	1696	1	lumped
mummed	10	44	1155	1	mummed
mumper	12	35	1352	1	mumper
pumped	13	39	1556	1	pumped
tumped	11	42	1623	1	tumped
umped	10	47	1727	1	_umped
amped	10	48	2051	2	_amped
bummed	13	42	1172	2	bummed
bumper	12	37	1434	2	bumper
burped	11	62	1550	2	burped
camped	13	47	2023	2	camped
chumped	17	37	949	2	chumped
clumped	14	36	1066	2	clumped
comped	13	59	1987	2	comped
crumped	14	43	1122	2	crumped
cupped	13	44	1398	2	cupped
cusped	11	43	1204	2	cusped
damped	12	43	1558	2	damped
dumbed	12	40	1208	2	dumbed
dumper	11	46	1521	2	dumper
duped	9	51	1832	2	du_ped
dupped	12	44	1164	2	dupped
flumped	15	37	771	2	flumped
fumed	11	61	1882	2	fum_ed
gimped	12	39	1147	2	gimped
grumped	13	33	733	2	grumped
gulped	10	46	1037	2	gulped
gummed	12	38	1166	2	gummed
hummed	14	48	1267	2	hummed
humper	13	41	1588	2	humper
humphed	18	3	542	2	humphed
imped	10	51	1797	2	_imped
jumper	17	36	1237	2	jumper
lamped	11	40	1754	2	lamped
limped	11	48	1712	2	limped
lumpen	10	40	1066	2	lumpen
lumper	10	38	1665	2	lumper
mapped	13	40	1588	2	mapped
mimed	10	56	2273	2	mim_ed
moped	10	54	2473	2	m_oped
mopped	13	41	1432	2	mopped
mucked	15	38	1609	2	mucked
mudded	11	45	1138	2	mudded
muffed	15	42	1059	2	muffed
mugged	11	41	1383	2	mugged
muled	8	58	2443	2	mu_led
mulled	9	47	2155	2	mulled
mumbled	14	30	1076	2	mumbled
mummer	9	36	1454	2	mummer
mummied	11	32	710	2	mummied
mump	10	54	2572	2	mump__
mumpers	13	33	1136	2	mumpers
mumps	11	56	1910	2	mump_s
mured	8	57	2670	2	mu_red
mused	8	55	2458	2	mu_sed
mushed	12	44	2084	2	mushed
mussed	9	44	1890	2	mussed
musted	9	33	2107	2	musted
muted	8	50	2338	2	mu_ted
numbed	11	41	1144	2	numbed
pimped	13	49	1348	2	pimped
plumped	14	31	864	2	plumped
pulped	11	46	1253	2	pulped
pumper	12	44	1555	2	pumper
pupped	10	50	1327	2	pupped
ramped	11	46	1790	2	ramped
romped	11	45	1365	2	romped
rumpled	12	38	1001	2	rumpled
slumped	12	37	1015	2	slumped
stumped	12	42	1015	2	stumped
summed	11	40	1404	2	summed
supped	11	44	1570	2	supped
tamped	11	43	1704	2	tamped
temped	11	39	1289	2	temped
thumped	15	38	741	2	thumped
trumped	12	43	971	2	trumped
tupped	11	40	1323	2	tupped
upped	10	37	1516	2	_upped
urped	8	46	1528	2	_urped
vamped	14	42	1101	2	vamped
whumped	18	33	563	2	whumped
wimped	14	42	1151	2	wimped

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	82551	0.236	757165.3
2	DLD Change Limit	82551	87	5.810	14208.4
3	Display Results	87	87	0.080	1087.5
	(SQL Overall)	178691	87	6.126	29169.3