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

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

47 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
hackie	15	46	1562	(None)
hackee	15	49	2183	1	hackee
hackies	16	34	1824	1	hackies
hackle	15	49	1681	1	hackle
hankie	13	39	1571	1	hankie
hawkie	16	38	1009	1	hawkie
hickie	15	38	1247	1	hickie
ackee	11	58	2537	2	_ackee
alkie	9	55	2003	2	_alkie
cackle	14	34	1692	2	cackle
darkie	11	37	1401	2	darkie
dickie	13	39	1311	2	dickie
duckie	13	35	1166	2	duckie
hack	13	51	3454	2	hack__
hacked	16	49	2351	2	hacked
hackees	16	50	1410	2	hackees
hacker	15	48	2269	2	hacker
hacking	17	37	2061	2	hacking
hackled	17	33	1249	2	hackled
hackler	16	35	1235	2	hackler
hackles	16	29	1706	2	hackles
hacklier	17	3	713	2	hacklier
hackly	18	29	873	2	hackly
hackmen	18	3	671	2	hackmen
hackney	19	3	512	2	hackney
hacks	14	49	2871	2	hack_s
hake	11	56	3784	2	ha_k_e
hakim	14	3	1183	2	ha_kim
hankies	14	36	1776	2	hankies
hawkies	17	33	1124	2	hawkies
heckle	15	31	1209	2	heckle
hickies	16	36	1474	2	hickies
honkie	13	30	1167	2	honkie
huckle	15	39	1307	2	huckle
hunkie	13	38	1238	2	hunkie
jackies	20	29	1262	2	jackies
luckie	12	36	1141	2	luckie
mackle	14	37	1643	2	mackle
rackle	12	39	1729	2	rackle
shackle	16	40	954	2	shackle
sickie	12	37	1574	2	sickie
tackier	13	37	1252	2	tackier
tackle	12	38	1573	2	tackle
talkie	10	39	1444	2	talkie
wacke	14	59	1862	2	wack_e
wackier	16	36	973	2	wackier
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	82551	0.343	520965.0
2	DLD Change Limit	82551	47	2.920	28270.9
3	Display Results	47	47	0.016	2937.5
	(SQL Overall)	178691	47	3.279	54495.6