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

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

81 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
munch	12	49	1710	(None)
bunch	12	51	1860	1	bunch
dunch	11	53	1626	1	dunch
hunch	13	64	1621	1	hunch
lunch	10	49	1724	1	lunch
much	11	52	2403	1	mu_ch
mulch	12	40	1297	1	mulch
mutch	12	50	1617	1	mutch
punch	12	51	1842	1	punch
bench	12	56	1950	2	bench
brunch	13	32	935	2	brunch
bunchy	16	43	746	2	bunchy
bunco	9	46	1608	2	bunco
butch	12	54	1654	2	butch
cinch	12	45	1624	2	cinch
conch	12	46	2007	2	conch
crunch	13	34	950	2	crunch
culch	12	45	1283	2	culch
curch	12	44	1541	2	curch
cutch	12	51	1619	2	cutch
dunce	8	63	1926	2	dunce
dutch	11	47	1382	2	dutch
eunuch	11	5	436	2	eunuch
finch	13	54	1697	2	finch
glunch	12	5	535	2	glunch
gulch	11	38	1060	2	gulch
haunch	14	37	734	2	haunch
hunh	10	63	2373	2	hun_h
hutch	13	54	1409	2	hutch
inch	9	54	2082	2	_inch
junco	14	46	1220	2	junco
kench	14	55	1392	2	kench
launch	11	36	806	2	launch
lurch	10	48	1463	2	lurch
lynch	13	46	898	2	lynch
mach	11	61	3448	2	m_ach
manche	13	35	1510	2	manche
march	12	56	2289	2	march
match	12	56	2110	2	match
mensch	13	38	709	2	mensch
mensh	10	54	1355	2	mensh
merch	12	54	1796	2	merch
milch	12	44	1337	2	milch
mince	9	53	2523	2	mince
mincy	12	58	1741	2	mincy
month	10	48	1842	2	month
mooch	12	53	1361	2	mooch
mouch	12	47	1580	2	mouch
mucho	12	50	1344	2	mu_cho
muck	12	57	2785	2	mu_ck
mulct	9	38	2008	2	mulct
mun	5	61	4386	2	mun__
munched	15	34	1107	2	munched
muncher	14	36	1037	2	muncher
munches	14	42	1579	2	munches
mungo	8	49	1605	2	mungo
muni	6	58	2441	2	mun_i
munis	7	50	2200	2	munis
muns	6	55	3592	2	mun_s
musca	9	3	1176	2	musca
mush	9	49	2912	2	mu_sh
musth	10	53	1478	2	musth
mynah	13	56	956	2	mynah
ouch	9	57	2463	2	ou_ch
ounce	7	70	1993	2	ounce
paunch	13	36	985	2	paunch
pinch	12	56	1930	2	pinch
punchy	16	39	852	2	punchy
quench	20	3	663	2	quench
ranch	10	50	1979	2	ranch
raunch	11	35	843	2	raunch
smutch	13	20	584	2	smutch
such	9	64	2481	2	su_ch
synch	13	50	1179	2	synch
tench	10	56	2000	2	tench
unci	6	50	1946	2	_unci
unco	6	60	2140	2	_unco
wench	13	62	1478	2	wench
winch	13	50	1666	2	winch
yucch	15	41	743	2	yucch
yuch	12	58	1853	2	yu_ch

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.140	1276364.3
2	DLD Change Limit	53800	81	1.533	35094.6
3	Display Results	81	81	0.013	6230.8
	(SQL Overall)	178691	81	1.686	105985.2