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

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

78 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
yucky	17	54	1169	(None)
ducky	15	42	1611	1	ducky
lucky	14	55	1501	1	lucky
mucky	16	50	1525	1	mucky
sucky	14	44	1550	1	sucky
yuck	13	64	2353	1	yuck_
yucks	14	47	1719	1	yucks
yukky	14	42	521	1	yukky
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
muck	12	57	2785	2	muck_
mucks	13	46	2264	2	mucks
murky	14	52	1668	2	murky
musky	14	47	1529	2	musky
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
yack	13	54	2597	2	yack_
yacks	14	44	1981	2	yacks
yechy	16	51	908	2	yechy
yeuky	15	54	703	2	yeuky
yock	13	59	2461	2	yock_
yocks	14	44	1837	2	yocks
yolky	15	52	952	2	yolky
yuca	9	57	1672	2	yuc_a
yucas	10	60	1391	2	yucas
yucca	12	46	744	2	yucca
yucch	15	41	743	2	yucch
yuch	12	58	1853	2	yuc_h
yucked	16	40	1356	2	yucked
yuk	10	67	2560	2	yu_k_
yuks	11	64	1802	2	yu_ks
yummy	15	42	915	2	yummy
yuppy	15	48	791	2	yuppy

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.093	1921408.6
2	DLD Change Limit	53800	78	1.766	30464.3
3	Display Results	78	78	0.046	1695.7
	(SQL Overall)	178691	78	1.905	93801.0