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

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

70 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
luckier	13	38	1153	(None)
duckier	14	39	1179	1	duckier
luckie	12	36	1141	1	luckie_
luckies	13	33	1368	1	luckies
muckier	15	34	1148	1	muckier
pluckier	16	29	507	1	pluckier
suckier	13	36	1397	1	suckier
yuckier	16	35	853	1	yuckier
blockier	16	6	613	2	blockier
bucker	14	54	2046	2	buck_er
buckler	15	41	1203	2	buckler
bulkier	13	41	1151	2	bulkier
clunkier	14	34	579	2	clunkier
cockier	15	40	1362	2	cockier
dickier	14	35	1245	2	dickier
ducker	13	43	1799	2	duck_er
duckie	13	35	1166	2	duckie_
duckies	14	36	1381	2	duckies
duskier	12	40	943	2	duskier
flockier	17	4	534	2	flockier
flukier	14	39	785	2	flu_kier
fucker	15	34	1442	2	fuck_er
funkier	14	34	998	2	funkier
gunkier	12	36	955	2	gunkier
hulkier	14	32	897	2	hulkier
hunkier	14	45	1214	2	hunkier
huskier	14	36	976	2	huskier
ickier	12	43	992	2	_ickier
junkier	18	33	949	2	junkier
kickier	12	34	905	2	kickier
lacier	8	40	2009	2	lac_ier
lacker	12	53	2562	2	lack_er
lakier	10	47	1627	2	l_akier
lankier	11	37	1163	2	lankier
larkier	11	37	1152	2	larkier
leakier	11	40	1099	2	leakier
licker	12	52	2204	2	lick_er
locker	12	40	1942	2	lock_er
lucifer	12	3	460	2	lucifer
lucked	13	51	1802	2	luck_ed
luckiest	14	30	1144	2	luckiest
luckily	16	29	708	2	luckily
lucking	14	36	1583	2	lucking
lumpier	11	34	1014	2	lumpier
lunier	6	46	1760	2	lu_nier
lunker	10	47	1834	2	lunk_er
lurker	10	36	1329	2	lurk_er
lustier	7	38	1350	2	lustier
luthier	10	3	823	2	luthier
mucker	14	38	1639	2	muck_er
murkier	13	31	1027	2	murkier
muskier	13	43	1273	2	muskier
peckier	15	39	1052	2	peckier
pickier	15	39	1297	2	pickier
plucker	15	36	824	2	pluck_er
plunkier	14	30	532	2	plunkier
pockier	15	39	1160	2	pockier
pucker	14	38	1763	2	puck_er
punkier	13	35	1279	2	punkier
quackier	23	21	537	2	quackier
quakier	20	23	920	2	quakier
rockier	13	49	1188	2	rockier
sucker	12	41	2066	2	suck_er
suckler	13	34	1309	2	suckler
sulkier	11	38	1196	2	sulkier
tackier	13	37	1252	2	tackier
tucker	12	43	1695	2	tuck_er
unluckier	15	4	193	2	unluckier
wackier	16	36	973	2	wackier
yukkier	13	26	389	2	yukkier

Search took 6 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	107671	0.140	1276364.3
2	DLD Change Limit	107671	70	5.063	21266.2
3	Display Results	70	70	0.016	4375.0
	(SQL Overall)	178691	70	5.219	34238.6