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

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

70 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
hackler	16	35	1235	(None)
cackler	15	38	1257	1	cackler
hacker	15	48	2269	1	hack_er
hackle	15	49	1681	1	hackle_
hackled	17	33	1249	1	hackled
hacklers	17	37	1030	1	hacklers
hackles	16	29	1706	1	hackles
hacklier	17	3	713	1	hacklier
heckler	16	27	857	1	heckler
shackler	17	31	797	1	shackler
tackler	13	40	1332	1	tackler
backer	14	45	2552	2	back_er
buckler	15	41	1203	2	buckler
cackle	14	34	1692	2	cackle_
cackled	16	46	1330	2	cackled
cacklers	16	37	1070	2	cacklers
cackles	15	37	1720	2	cackles
chuckler	19	3	555	2	chuckler
dacker	13	49	2075	2	dack_er
fickler	16	34	842	2	fickler
hacked	16	49	2351	2	hack_ed
hackee	15	49	2183	2	hack_ee
hackees	16	50	1410	2	hackees
hackers	16	46	1904	2	hack_ers
hackie	15	46	1562	2	hackie_
hackies	16	34	1824	2	hackies
hackly	18	29	873	2	hackl_y
hackmen	18	3	671	2	hackmen
hackney	19	3	512	2	hackney
haggler	12	32	893	2	haggler
hailer	9	47	2034	2	ha_iler
haler	8	50	3352	2	ha__ler
handler	11	35	1616	2	handler
hanker	13	46	2209	2	hank_er
hauler	9	50	1512	2	ha_uler
hawker	16	48	1266	2	hawk_er
heckle	15	31	1209	2	heckle_
heckled	17	31	846	2	heckled
hecklers	17	35	712	2	hecklers
heckles	16	37	1138	2	heckles
hocker	15	51	1856	2	hock_er
huckle	15	39	1307	2	huckle_
huckles	16	36	1262	2	huckles
jacker	19	44	1758	2	jack_er
jackleg	21	3	504	2	jackleg
lacker	12	53	2562	2	lack_er
mackle	14	37	1643	2	mackle_
mackled	16	41	1192	2	mackled
mackles	15	44	1575	2	mackles
mickler	15	33	1023	2	mickler
packer	14	42	2340	2	pack_er
racker	12	48	2455	2	rack_er
rackle	12	39	1729	2	rackle_
sacker	12	51	2484	2	sack_er
shackle	16	40	954	2	shackle_
shackled	18	27	760	2	shackled
shacklers	18	33	603	2	shacklers
shackles	17	30	1059	2	shackles
suckler	13	34	1309	2	suckler
tacker	12	42	2450	2	tack_er
tackier	13	37	1252	2	tackier
tackle	12	38	1573	2	tackle_
tackled	14	39	1319	2	tackled
tacklers	14	30	1077	2	tacklers
tackles	13	38	1652	2	tackles
tickler	13	36	1265	2	tickler
wacker	15	49	2012	2	wack_er
wackier	16	36	973	2	wackier
whacker	19	36	850	2	whack_er
whackier	20	4	467	2	whackier

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.360	496363.9
2	DLD Change Limit	107671	70	2.923	36835.8
3	Display Results	70	70	0.016	4375.0
	(SQL Overall)	178691	70	3.299	54165.2