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

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

76 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
hackled	17	33	1249	(None)
cackled	16	46	1330	1	cackled
hacked	16	49	2351	1	hack_ed
hackle	15	49	1681	1	hackle_
hackler	16	35	1235	1	hackler
hackles	16	29	1706	1	hackles
heckled	17	31	846	1	heckled
mackled	16	41	1192	1	mackled
shackled	18	27	760	1	shackled
tackled	14	39	1319	1	tackled
ankled	11	43	1348	2	_ankled
backed	15	57	2572	2	back_ed
buckled	16	44	1188	2	buckled
cackle	14	34	1692	2	cackle_
cackler	15	38	1257	2	cackler
cackles	15	37	1720	2	cackles
chuckled	20	4	516	2	chuckled
cockled	16	37	1082	2	cockled
crackled	17	42	886	2	crackled
darkled	13	37	872	2	darkled
hackee	15	49	2183	2	hack_ee
hackees	16	50	1410	2	hackees
hacker	15	48	2269	2	hack_er
hackie	15	46	1562	2	hackie_
hackies	16	34	1824	2	hackies
hacklers	17	37	1030	2	hacklers
hacklier	17	3	713	2	hacklier
hackly	18	29	873	2	hackl_y
hackmen	18	3	671	2	hackmen
hackney	19	3	512	2	hackney
haggled	13	35	928	2	haggled
hailed	10	41	2274	2	ha_iled
haled	9	53	3582	2	ha__led
handled	12	41	1453	2	handled
hanked	14	42	2060	2	hank_ed
harked	14	54	2255	2	hark_ed
hassled	11	35	830	2	hassled
hauled	10	44	1521	2	ha_uled
hawked	17	47	1267	2	hawk_ed
heckle	15	31	1209	2	heckle_
heckler	16	27	857	2	heckler
heckles	16	37	1138	2	heckles
hocked	16	55	2130	2	hock_ed
huckle	15	39	1307	2	huckle_
huckles	16	36	1262	2	huckles
jacked	20	48	1752	2	jack_ed
jackleg	21	3	504	2	jackleg
keckled	13	37	650	2	keckled
lacked	13	53	2465	2	lack_ed
mackle	14	37	1643	2	mackle_
mackles	15	44	1575	2	mackles
macled	11	67	1811	2	mac_led
maculed	12	35	1005	2	maculed
nickled	14	40	1044	2	nickled
packed	15	48	2260	2	pack_ed
pickled	16	40	1188	2	pickled
racked	13	45	2608	2	rack_ed
rackle	12	39	1729	2	rackle_
rankled	12	39	1065	2	rankled
ruckled	14	41	1103	2	ruckled
sacked	13	55	2521	2	sack_ed
shacked	17	40	1539	2	shack_ed
shackle	16	40	954	2	shackle_
shackler	17	31	797	2	shackler
shackles	17	30	1059	2	shackles
sickled	14	47	1343	2	sickled
spackled	17	29	780	2	spackled
suckled	14	42	1251	2	suckled
tacked	13	47	2394	2	tack_ed
tackle	12	38	1573	2	tackle_
tackler	13	40	1332	2	tackler
tackles	13	38	1652	2	tackles
thacked	17	38	1020	2	thack_ed
tickled	14	43	1313	2	tickled
whacked	20	45	862	2	whack_ed
yacked	16	45	1679	2	yack_ed

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	76	3.000	35890.3
3	Display Results	76	76	0.016	4750.0
	(SQL Overall)	178691	76	3.389	52726.8