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

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

85 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
hackles	16	29	1706	(None)
cackles	15	37	1720	1	cackles
hackees	16	50	1410	1	hackees
hackies	16	34	1824	1	hackies
hackle	15	49	1681	1	hackle_
hackled	17	33	1248	1	hackled
hackler	16	35	1235	1	hackler
hacklers	17	37	1030	1	hacklers
heckles	16	37	1138	1	heckles
huckles	16	36	1262	1	huckles
mackles	15	44	1575	1	mackles
shackles	17	30	1059	1	shackles
tackles	13	38	1652	1	tackles
ackees	12	49	1457	2	_ackees
ankles	10	48	1838	2	_ankles
backless	16	29	1063	2	backless
buckles	15	34	1609	2	buckles
cackle	14	34	1692	2	cackle_
cackled	16	46	1329	2	cackled
cackler	15	38	1257	2	cackler
cacklers	16	37	1070	2	cacklers
chuckles	19	3	680	2	chuckles
cockles	15	34	1464	2	cockles
crackles	16	41	1127	2	crackles
darkles	12	40	1193	2	darkles
deckles	14	33	1280	2	deckles
grackles	15	30	918	2	grackles
hacked	16	49	2351	2	hack_ed
hackee	15	49	2183	2	hack_ee
hacker	15	48	2269	2	hack_er
hackers	16	46	1904	2	hackers
hackie	15	46	1562	2	hackie_
hacklier	17	3	713	2	hacklier
hackliest	18	3	652	2	hackliest
hackly	18	29	873	2	hackl_y
hackmen	18	3	671	2	hackmen
hackney	19	3	512	2	hackney
hackneys	20	3	368	2	hackneys
hacks	14	49	2871	2	hack__s
haggles	12	33	1248	2	haggles
hakes	12	60	3430	2	ha_k_es
hales	8	54	4984	2	ha__les
handles	11	40	2065	2	handles
hankies	14	36	1776	2	hankies
hantles	10	41	1751	2	hantles
haoles	9	49	1980	2	ha_oles
hassles	10	34	1169	2	hassles
hawkies	17	33	1124	2	hawkies
heckle	15	31	1209	2	heckle_
heckled	17	31	846	2	heckled
heckler	16	27	857	2	heckler
hecklers	17	35	712	2	hecklers
hickies	16	36	1474	2	hickies
huckle	15	39	1307	2	huckle_
jacales	16	3	1032	2	jacales
jackies	20	29	1262	2	jackies
jackleg	21	3	503	2	jackleg
jacklegs	22	3	395	2	jacklegs
keckles	12	31	876	2	keckles
mackle	14	37	1643	2	mackle_
mackled	16	41	1191	2	mackled
macles	10	70	2322	2	mac_les
macules	11	40	1513	2	macules
mickles	15	34	1500	2	mickles
muckles	15	34	1325	2	muckles
nickles	13	37	1382	2	nickles
pickles	15	32	1544	2	pickles
rackle	12	39	1729	2	rackle_
rankles	11	31	1454	2	rankles
ruckles	13	34	1460	2	ruckles
shackle	16	40	954	2	shackle_
shackled	18	27	759	2	shackled
shackler	17	31	797	2	shackler
shacklers	18	33	603	2	shacklers
shackoes	17	36	785	2	shackoes
sickles	13	34	1754	2	sickles
spackles	16	31	994	2	spackles
suckles	13	45	1674	2	suckles
tackle	12	38	1573	2	tackle_
tackled	14	39	1318	2	tackled
tackler	13	40	1332	2	tackler
tacklers	14	30	1077	2	tacklers
tackless	14	41	948	2	tackless
tickles	13	34	1685	2	tickles
wackes	15	47	1771	2	wack_es

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.283	631417.0
2	DLD Change Limit	107671	85	4.780	22525.3
3	Display Results	85	85	0.030	2833.3
	(SQL Overall)	178691	85	5.093	35085.6