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

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

78 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
hackee	15	49	2183	(None)
ackee	11	58	2536	1	_ackee
hacked	16	49	2351	1	hacked
hackees	16	50	1410	1	hackees
hacker	15	48	2269	1	hacker
hackie	15	46	1562	1	hackie
hackle	15	49	1681	1	hackle
ackees	12	49	1457	2	_ackees
akee	8	59	3681	2	_a_kee
backed	15	57	2572	2	backed
backer	14	45	2552	2	backer
cackle	14	34	1692	2	cackle
chickee	18	31	1155	2	chickee
dacker	13	49	2075	2	dacker
hacek	14	54	1184	2	hac_ek
haceks	15	44	786	2	haceks
hack	13	51	3454	2	hack__
hackers	16	46	1904	2	hackers
hackies	16	34	1824	2	hackies
hackled	17	33	1248	2	hackled
hackler	16	35	1235	2	hackler
hackles	16	29	1706	2	hackles
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
hadjee	17	41	1182	2	hadjee
hake	11	56	3784	2	ha_k_e
hakeem	15	40	738	2	ha_keem
hakes	12	60	3430	2	ha_kes
hanked	14	42	2060	2	hanked
hanker	13	46	2209	2	hanker
hankie	13	39	1571	2	hankie
harked	14	54	2255	2	harked
harken	13	51	1634	2	harken
hawked	17	47	1267	2	hawked
hawker	16	48	1266	2	hawker
hawkey	19	50	763	2	hawkey
hawkie	16	38	1009	2	hawkie
heckle	15	31	1209	2	heckle
hickey	18	50	1199	2	hickey
hickie	15	38	1247	2	hickie
hocked	16	55	2130	2	hocked
hocker	15	51	1856	2	hocker
hockey	18	48	1315	2	hockey
huckle	15	39	1307	2	huckle
jacked	20	48	1752	2	jacked
jacker	19	44	1758	2	jacker
jacket	19	47	2067	2	jacket
lacked	13	53	2465	2	lacked
lacker	12	53	2562	2	lacker
lackey	15	48	1335	2	lackey
mackle	14	37	1643	2	mackle
packed	15	48	2260	2	packed
packer	14	42	2340	2	packer
packet	14	47	2650	2	packet
racked	13	45	2608	2	racked
racker	12	48	2455	2	racker
racket	12	52	2942	2	racket
rackle	12	39	1729	2	rackle
rakee	9	60	3117	2	ra_kee
sacked	13	55	2521	2	sacked
sacker	12	51	2484	2	sacker
shacked	17	40	1539	2	shacked
shackle	16	40	954	2	shackle
sickee	12	46	2222	2	sickee
tacked	13	47	2394	2	tacked
tacker	12	42	2450	2	tacker
tacket	12	46	2749	2	tacket
tackey	15	46	1308	2	tackey
tackle	12	38	1573	2	tackle
thacked	17	38	1020	2	thacked
wacke	14	59	1862	2	wack_e
wacker	15	49	2012	2	wacker
wackes	15	47	1771	2	wackes
whacked	20	45	862	2	whacked
whacker	19	36	850	2	whacker
yacked	16	45	1679	2	yacked

Search took 3 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.110	1624463.6
2	DLD Change Limit	82551	78	2.796	29524.7
3	Display Results	78	78	0.033	2363.6
	(SQL Overall)	178691	78	2.939	60799.9