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

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

63 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
muckles	15	34	1325	(None)
buckles	15	34	1609	1	buckles
huckles	16	36	1262	1	huckles
mackles	15	44	1575	1	mackles
mickles	15	34	1500	1	mickles
muckle	14	34	1358	1	muckle_
ruckles	13	34	1460	1	ruckles
suckles	13	45	1674	1	suckles
buckle	14	48	1519	2	buckle_
buckled	16	44	1188	2	buckled
buckler	15	41	1203	2	buckler
bucklers	16	34	950	2	bucklers
buckoes	15	38	1039	2	buckoes
cackles	15	37	1720	2	cackles
chuckles	19	3	680	2	chuckles
cockles	15	34	1464	2	cockles
deckles	14	33	1280	2	deckles
duckies	14	36	1381	2	duckies
hackles	16	29	1706	2	hackles
heckles	16	37	1138	2	heckles
huckle	15	39	1307	2	huckle_
keckles	12	31	876	2	keckles
knuckles	13	8	445	2	knuckles
luckies	13	33	1368	2	luckies
luckless	14	26	589	2	luckless
mackle	14	37	1643	2	mackle_
mackled	16	41	1192	2	mackled
macles	10	70	2322	2	mac_les
macules	11	40	1513	2	macules
mickle	14	37	1513	2	mickle_
mickler	15	33	1023	2	mickler
micklest	16	21	912	2	micklest
muches	13	47	1899	2	muc_hes
mucked	15	38	1609	2	muck_ed
mucker	14	38	1639	2	muck_er
muckers	15	36	1280	2	muckers
muckier	15	34	1148	2	muckier
muckiest	16	32	1091	2	muckiest
mucks	13	46	2264	2	muck__s
mucuses	11	14	851	2	mucuses
muddles	11	29	1435	2	muddles
muffles	15	39	1045	2	muffles
mules	7	50	3429	2	mu__les
mumbles	13	30	1443	2	mumbles
muscles	11	3	1056	2	muscles
muskies	13	36	1467	2	muskies
mutules	9	3	1184	2	mutules
muzzles	17	29	968	2	muzzles
myceles	14	3	521	2	myceles
nickles	13	37	1382	2	nickles
pickles	15	32	1544	2	pickles
ruckle	12	44	1458	2	ruckle_
ruckled	14	41	1103	2	ruckled
runkles	11	41	1194	2	runkles
sickles	13	34	1754	2	sickles
suckle	12	40	1596	2	suckle_
suckled	14	42	1251	2	suckled
suckler	13	34	1310	2	suckler
sucklers	14	37	996	2	sucklers
suckless	14	28	882	2	suckless
tackles	13	38	1652	2	tackles
tickles	13	34	1685	2	tickles
truckles	14	31	938	2	truckles

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.373	479064.3
2	DLD Change Limit	107671	63	3.156	34116.3
3	Display Results	63	63	0.016	3937.5
	(SQL Overall)	178691	63	3.545	50406.5