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

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

54 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
duckies	14	36	1381	(None)
dickies	14	34	1634	1	dickies
duchies	13	33	1231	1	duchies
duckie	13	35	1166	1	duckie_
duckier	14	39	1179	1	duckier
duckiest	15	32	1186	1	duckiest
luckies	13	33	1368	1	luckies
buckles	15	34	1609	2	buckles
buckoes	15	38	1039	2	buckoes
chuckies	19	3	770	2	chuckies
darkies	12	40	1575	2	darkies
deckles	14	33	1280	2	deckles
decries	10	33	1981	2	decries
dickie	13	39	1311	2	dickie_
dickier	14	35	1245	2	dickier
dickiest	15	34	1250	2	dickiest
dinkies	12	37	1603	2	dinkies
duces	8	63	2747	2	duc__es
ducked	14	47	1801	2	duck_ed
ducker	13	43	1799	2	duck_er
duckers	14	32	1471	2	duckers
ducking	15	43	1505	2	ducking
duckpins	17	4	369	2	duckpins
ducks	12	48	2321	2	duck__s
dukes	10	50	2347	2	du_k_es
dummies	12	30	1213	2	dummies
durries	8	38	1735	2	durries
duskier	12	40	943	2	duskier
duskiest	13	37	1008	2	duskiest
duties	7	49	2190	2	du_ties
hackies	16	34	1824	2	hackies
hickies	16	36	1474	2	hickies
huckles	16	36	1262	2	huckles
hunkies	14	32	1450	2	hunkies
huskies	14	32	1208	2	huskies
jackies	20	29	1262	2	jackies
junkies	18	37	1169	2	junkies
luckie	12	36	1141	2	luckie_
luckier	13	38	1153	2	luckier
luckiest	14	30	1144	2	luckiest
muckier	15	34	1148	2	muckier
muckiest	16	32	1091	2	muckiest
muckles	15	34	1325	2	muckles
muskies	13	36	1467	2	muskies
punkies	13	42	1680	2	punkies
quickies	23	3	677	2	quickies
ruckles	13	34	1460	2	ruckles
sickies	13	37	1750	2	sickies
suckier	13	36	1397	2	suckier
suckiest	14	33	1411	2	suckiest
suckles	13	45	1674	2	suckles
sulkies	11	43	1576	2	sulkies
yuckier	16	35	853	2	yuckier
yuckiest	17	32	883	2	yuckiest

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.780	229091.0
2	DLD Change Limit	107671	54	5.046	21337.9
3	Display Results	54	54	0.016	3375.0
	(SQL Overall)	178691	54	5.842	30587.3