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

Here are the results of your fuzzy-string dictionary search for “lucky” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

101 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
lucky	14	55	1501	(None)
ducky	15	42	1611	1	ducky
luck	10	53	2982	1	luck_
lucks	11	57	2356	1	lucks
mucky	16	50	1525	1	mucky
plucky	17	40	658	1	plucky
sucky	14	44	1550	1	sucky
yucky	17	54	1169	1	yucky
blocky	17	38	835	2	blocky
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
cluck	13	49	1489	2	cluck_
clucks	14	45	1207	2	clucks
clunky	15	44	789	2	clunky
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
flecky	18	38	765	2	flecky
flocky	18	46	842	2	flocky
fluky	15	45	1229	2	flu_ky
flunky	16	40	809	2	flunky
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
lacey	10	58	2091	2	lacey
lack	10	58	3768	2	lack_
lackey	15	48	1335	2	lackey
lacks	11	61	2920	2	lacks
lacy	9	58	2963	2	lac_y
laky	11	67	2582	2	l_aky
lanky	12	55	1748	2	lanky
larky	12	52	1887	2	larky
leaky	12	52	1772	2	leaky
lick	10	69	3507	2	lick_
licks	11	53	2539	2	licks
linky	12	76	2238	2	linky
lock	10	61	3436	2	lock_
locks	11	51	2692	2	locks
luce	6	51	3257	2	luc_e
luces	7	55	2843	2	luces
lucid	8	43	1457	2	lucid
lucked	13	51	1802	2	lucked
luckie	12	36	1141	2	luckie
luckily	16	29	708	2	luckily
lucre	7	64	1552	2	lucre
lumpy	12	66	1591	2	lumpy
lunk	8	60	3072	2	lunk_
lunks	9	48	2245	2	lunks
luny	7	73	2413	2	lu_ny
lurk	8	66	2416	2	lurk_
lurks	9	52	1874	2	lurks
lusty	8	54	1757	2	lusty
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
pluck	13	42	1230	2	pluck_
plucks	14	37	973	2	plucks
plunky	15	37	795	2	plunky
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
unlucky	16	4	322	2	unlucky
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.080	2233637.5
2	DLD Change Limit	53800	101	1.670	32215.6
3	Display Results	101	101	0.016	6312.5
	(SQL Overall)	178691	101	1.766	101184.0