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

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

91 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
mumper	12	35	1352	(None)
bumper	12	37	1434	1	bumper
dumper	11	46	1521	1	dumper
humper	13	41	1588	1	humper
jumper	17	36	1237	1	jumper
lumper	10	38	1665	1	lumper
mummer	9	36	1454	1	mummer
mumped	13	38	1316	1	mumped
mumpers	13	33	1137	1	mumpers
pumper	12	44	1555	1	pumper
bummer	12	40	1410	2	bummer
bumped	13	44	1400	2	bumped
bumpers	13	39	1205	2	bumpers
bumpier	13	35	920	2	bumpier
camper	12	47	2221	2	camper
cumber	12	40	1670	2	cumber
cummer	12	44	1459	2	cummer
cupper	12	43	1386	2	cupper
damper	11	41	1775	2	damper
dumber	11	44	1417	2	dumber
dumped	12	38	1449	2	dumped
dumpers	12	34	1266	2	dumpers
dumpier	12	40	965	2	dumpier
duper	8	55	1900	2	du_per
fumer	10	59	1823	2	fum_er
fumier	11	3	1090	2	fumier
gulper	9	34	1021	2	gulper
gummer	11	46	1545	2	gummer
hamper	13	45	1865	2	hamper
hummer	13	36	1527	2	hummer
humped	14	40	1524	2	humped
humpers	14	27	1352	2	humpers
humpier	14	31	1072	2	humpier
jimper	17	38	986	2	jimper
jumped	18	35	1155	2	jumped
jumpers	18	39	984	2	jumpers
jumpier	18	31	794	2	jumpier
limper	10	41	1785	2	limper
lumber	10	38	1777	2	lumber
lumped	11	42	1696	2	lumped
lumpen	10	40	1066	2	lumpen
lumpers	11	35	1448	2	lumpers
lumpier	11	34	1014	2	lumpier
mammer	9	42	1886	2	mammer
mamzer	19	45	983	2	mamzer
mapper	12	45	1609	2	mapper
member	12	25	885	2	member
mimer	9	48	2576	2	mim_er
momser	10	40	1141	2	momser
momzer	19	32	755	2	momzer
moper	9	49	2592	2	m_oper
mopper	12	62	1500	2	mopper
mucker	14	38	1639	2	mucker
mudder	10	44	1349	2	mudder
mugger	10	39	1470	2	mugger
muller	8	38	2035	2	muller
mumbler	13	35	1091	2	mumbler
mummed	10	44	1155	2	mummed
mummers	10	37	1284	2	mummers
mummery	13	33	666	2	mummery
mump	10	54	2572	2	mump__
mumps	11	56	1910	2	mump_s
murder	9	36	1378	2	murder
murker	12	37	1524	2	murker
muser	7	60	2412	2	mu_ser
musher	11	38	2057	2	musher
muster	8	47	2452	2	muster
muter	7	45	2554	2	mu_ter
mutter	8	44	1888	2	mutter
number	10	39	1322	2	number
pamper	12	43	1666	2	pamper
plumper	13	31	877	2	plumper
pulper	10	35	1327	2	pulper
pumped	13	39	1556	2	pumped
pumpers	13	31	1367	2	pumpers
romper	10	42	1368	2	romper
rummer	10	47	1548	2	rummer
simper	10	36	1629	2	simper
stumper	11	36	1009	2	stumper
summer	10	40	1771	2	summer
sumpter	11	3	887	2	sumpter
super	7	49	2448	2	su_per
supper	10	41	1543	2	supper
tamper	10	46	1851	2	tamper
temper	10	39	1409	2	temper
thumper	14	35	695	2	thumper
tumped	11	42	1623	2	tumped
umber	9	46	1759	2	_umber
umped	10	47	1727	2	_umped
upper	9	37	1426	2	_upper
vamper	13	42	1265	2	vamper

Search took 4 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.343	520965.0
2	DLD Change Limit	82551	91	3.000	27517.0
3	Display Results	91	91	0.033	2757.6
	(SQL Overall)	178691	91	3.376	52929.8