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

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

65 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
duckier	14	39	1179	(None)
dickier	14	35	1245	1	dickier
ducker	13	43	1799	1	duck_er
duckie	13	35	1166	1	duckie_
duckies	14	36	1381	1	duckies
duskier	12	40	943	1	duskier
luckier	13	38	1153	1	luckier
muckier	15	34	1148	1	muckier
suckier	13	36	1397	1	suckier
yuckier	16	35	853	1	yuckier
bucker	14	54	2046	2	buck_er
buckler	15	41	1203	2	buckler
bulkier	13	41	1151	2	bulkier
cockier	15	40	1362	2	cockier
dacker	13	49	2075	2	dack_er
decker	13	52	1599	2	deck_er
decrier	10	27	1355	2	decrier
dicier	9	44	1623	2	dic_ier
dicker	13	45	2140	2	dick_er
dickie	13	39	1311	2	dickie_
dickies	14	34	1634	2	dickies
dictier	10	34	1186	2	dictier
dinkier	12	34	1150	2	dinkier
docker	13	44	1765	2	dock_er
dorkier	12	28	1002	2	dorkier
duchies	13	33	1231	2	duchies
ducked	14	47	1801	2	duck_ed
duckers	14	32	1471	2	duck_ers
duckiest	15	32	1186	2	duckiest
ducking	15	43	1505	2	ducking
duiker	11	41	1059	2	duik_er
dumpier	12	40	965	2	dumpier
dungier	9	36	858	2	dungier
dunker	11	36	1646	2	dunk_er
dustier	8	38	1413	2	dustier
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
luckie	12	36	1141	2	luckie_
luckies	13	33	1368	2	luckies
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
pluckier	16	29	507	2	pluckier
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
wackier	16	36	973	2	wackier
yukkier	13	26	389	2	yukkier

Search took 4 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.356	501941.0
2	DLD Change Limit	107671	65	2.956	36424.6
3	Display Results	65	65	0.013	5000.0
	(SQL Overall)	178691	65	3.325	53741.7