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

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

75 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
honkey	16	51	1382	(None)
donkey	14	44	973	1	donkey
hockey	18	48	1315	1	hockey
hokey	15	54	2218	1	ho_key
honey	11	56	2991	1	hon_ey
honked	14	45	1791	1	honked
honker	13	41	1746	1	honker
honkeys	17	43	951	1	honkeys
honky	15	62	1852	1	honk_y
hookey	16	47	1393	1	hookey
hunkey	16	42	1088	1	hunkey
monkey	15	37	1059	1	monkey
boney	10	52	2731	2	bon_ey
bonked	13	55	1731	2	bonked
chokey	18	48	1171	2	cho_key
coney	10	59	3288	2	con_ey
conked	13	50	1911	2	conked
conker	12	47	2155	2	conker
conky	14	58	1874	2	conk_y
convey	14	46	1022	2	convey
cookey	15	54	1433	2	cookey
dinkey	14	48	1276	2	dinkey
donkeys	15	42	666	2	donkeys
hanked	14	42	2060	2	hanked
hanker	13	46	2209	2	hanker
hanky	15	54	1829	2	hank_y
hawkey	19	50	763	2	hawkey
henley	12	3	748	2	henley
hickey	18	50	1199	2	hickey
hinky	15	56	1875	2	hink_y
hocked	16	55	2130	2	hocked
hocker	15	51	1856	2	hocker
hockeys	19	50	927	2	hockeys
hoke	11	59	3593	2	ho_ke_
hoked	13	53	2699	2	ho_ked
hokes	12	62	3164	2	ho_kes
holey	11	56	2690	2	ho_ley
holked	14	49	1366	2	holked
homey	13	59	2484	2	ho_mey
hone	7	75	4932	2	hon_e_
honed	9	53	3226	2	hon_ed
honer	8	53	3209	2	hon_er
hones	8	81	4449	2	hon_es
honeys	12	40	1608	2	hon_eys
honied	10	48	1839	2	honied
honk	11	69	3119	2	honk__
honkers	14	33	1523	2	honkers
honkie	13	30	1166	2	honkie
honkies	14	30	1514	2	honkies
honks	12	51	2452	2	honk_s
hooey	11	49	2660	2	ho_oey
hooked	14	53	2055	2	hooked
hooker	13	48	2017	2	hooker
hookeys	17	44	895	2	hookeys
hooky	15	52	2026	2	hook_y
horsey	12	51	1540	2	horsey
hosey	11	61	2702	2	ho_sey
howked	17	73	1234	2	howked
hunker	13	39	1767	2	hunker
hunkeys	17	38	619	2	hunkeys
hunky	15	54	1773	2	hunk_y
jockey	22	40	803	2	jockey
jokey	19	50	1469	2	jo_key
konked	10	40	1058	2	konked
money	10	48	2684	2	mon_ey
monkery	16	31	744	2	monkery
monkeys	16	40	742	2	monkeys
phoney	14	36	1298	2	phon_ey
pinkey	15	43	1467	2	pinkey
pokey	14	53	1897	2	po_key
punkey	15	40	1117	2	punkey
toney	8	60	2741	2	ton_ey
wonky	15	40	1177	2	wonk_y
yonker	13	41	1085	2	yonker
zonked	20	42	947	2	zonked

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.203	880251.2
2	DLD Change Limit	82551	75	3.126	26407.9
3	Display Results	75	75	0.030	2500.0
	(SQL Overall)	178691	75	3.359	53197.7