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

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

100 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
mucky	16	50	1525	(None)
ducky	15	42	1611	1	ducky
lucky	14	55	1501	1	lucky
muck	12	57	2785	1	muck_
mucks	13	46	2264	1	mucks
murky	14	52	1668	1	murky
musky	14	47	1529	1	musky
sucky	14	44	1550	1	sucky
yucky	17	54	1169	1	yucky
amuck	13	8	956	2	amuck_
amucks	14	6	600	2	amucks
buck	12	51	2990	2	buck_
bucko	13	46	1402	2	bucko
bucks	13	48	2429	2	bucks
bulky	14	62	1557	2	bulky
chucky	20	41	800	2	chucky
cocky	16	42	1593	2	cocky
dicky	15	48	1624	2	dicky
duchy	14	43	1087	2	duchy
duck	11	59	2917	2	duck_
ducks	12	48	2321	2	ducks
dumky	15	45	1134	2	dumky
dusky	13	52	1304	2	dusky
fuck	13	49	2463	2	fuck_
fucks	14	44	1925	2	fucks
funky	15	43	1513	2	funky
guck	11	49	2253	2	guck_
gucks	12	39	1730	2	gucks
gunky	13	55	1411	2	gunky
huck	13	59	2763	2	huck_
hucks	14	43	2217	2	hucks
hulky	15	53	1247	2	hulky
hunky	15	54	1773	2	hunky
husky	15	61	1256	2	husky
icky	13	63	1575	2	_icky
jacky	21	54	1234	2	jacky
junky	19	45	1323	2	junky
kicky	13	50	1233	2	kicky
luck	10	53	2982	2	luck_
lucks	11	57	2356	2	lucks
mack	12	57	3365	2	mack_
macks	13	51	2760	2	macks
mick	12	63	3343	2	mick_
mickey	17	42	1185	2	mickey
micks	13	55	2537	2	micks
milky	14	40	1444	2	milky
mirky	14	63	1552	2	mirky
mock	12	64	2944	2	mock_
mocks	13	50	2382	2	mocks
much	11	52	2403	2	muc_h
muchly	16	8	620	2	muchly
mucho	12	50	1344	2	mucho
mucid	10	41	1525	2	mucid
mucin	9	31	1682	2	mucin
mucked	15	38	1609	2	mucked
mucker	14	38	1639	2	mucker
muckily	18	27	774	2	muckily
muckle	14	34	1358	2	muckle
mucor	9	40	1194	2	mucor
mucro	9	45	1372	2	mucro
mucus	9	40	1574	2	mucus
muddy	12	38	1223	2	muddy
muggy	12	56	1237	2	muggy
muhly	13	5	852	2	muhly
muley	10	48	1928	2	muley
mummy	11	49	1362	2	mummy
murk	10	55	2725	2	murk_
murkly	15	36	830	2	murkly
murks	11	48	2173	2	murks
murry	10	51	2023	2	murry
muscly	13	3	745	2	muscly
mushy	13	53	1663	2	mushy
musk	10	45	2619	2	musk_
musks	11	61	1964	2	musks
mussy	10	41	1764	2	mussy
musty	10	56	2095	2	musty
muzzy	18	84	1060	2	muzzy
pecky	16	55	1509	2	pecky
picky	16	54	1694	2	picky
plucky	17	40	658	2	plucky
pocky	16	53	1460	2	pocky
puck	12	49	2794	2	puck_
pucka	13	34	1280	2	pucka
pucks	13	43	2210	2	pucks
punky	14	44	1939	2	punky
quacky	24	37	696	2	quacky
quaky	21	43	1074	2	quaky
rocky	14	45	1385	2	rocky
ruck	10	47	2833	2	ruck_
rucks	11	44	2205	2	rucks
suck	10	61	3173	2	suck_
sucks	11	45	2307	2	sucks
sulky	12	47	1536	2	sulky
tacky	14	56	1744	2	tacky
tuck	10	46	2657	2	tuck_
tucks	11	47	2112	2	tucks
wacky	17	47	1493	2	wacky
yuck	13	64	2353	2	yuck_
yucks	14	47	1719	2	yucks
yukky	14	42	521	2	yukky

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.326	548131.9
2	DLD Change Limit	53800	100	1.516	35488.1
3	Display Results	100	100	0.013	7692.3
	(SQL Overall)	178691	100	1.855	96329.4