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

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

67 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
monkey	15	37	1059	(None)
donkey	14	44	973	1	donkey
honkey	16	51	1382	1	honkey
money	10	48	2684	1	mon_ey
monkery	16	31	745	1	monkery
monkeys	16	40	742	1	monkeys
boney	10	52	2731	2	bon_ey
bonked	13	55	1731	2	bonked
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
hockey	18	48	1315	2	hockey
hokey	15	54	2218	2	ho_key
honey	11	56	2991	2	hon_ey
honked	14	45	1791	2	honked
honker	13	41	1746	2	honker
honkeys	17	43	951	2	honkeys
honky	15	62	1852	2	honk_y
hookey	16	47	1393	2	hookey
hunkey	16	42	1088	2	hunkey
jockey	22	40	803	2	jockey
jokey	19	50	1469	2	jo_key
konked	10	40	1058	2	konked
mangey	12	36	1452	2	mangey
mickey	17	42	1185	2	mickey
minke	11	54	2176	2	minke_
minkes	12	46	1878	2	minkes
mocked	15	47	1661	2	mocked
mocker	14	33	1544	2	mocker
mockery	18	37	691	2	mockery
moke	10	62	3422	2	mo_ke_
mokes	11	46	3103	2	mo_kes
monde	8	57	2314	2	monde_
mondes	9	43	2235	2	mondes
moneys	11	55	1362	2	mon_eys
monger	9	44	1833	2	monger
monie	7	56	3165	2	monie_
monied	9	43	1946	2	monied
monies	8	32	3316	2	monies
moniker	13	3	867	2	moniker
monk	10	59	2852	2	monk__
monkeyed	18	4	415	2	monkeyed
monks	11	61	2339	2	monk_s
monody	12	3	824	2	monody
monoecy	14	4	508	2	monoecy
monte	7	58	2977	2	monte_
montes	8	42	2693	2	montes
mony	9	68	3001	2	mon__y
mooley	11	3	1163	2	mooley
mopey	12	48	2182	2	mo_pey
mosey	10	59	2287	2	mo_sey
motey	10	59	2295	2	mo_tey
motley	11	3	938	2	motley
mousey	11	52	1619	2	mousey
pinkey	15	43	1467	2	pinkey
pokey	14	53	1897	2	po_key
punkey	15	40	1117	2	punkey
smokey	15	39	865	2	smo_key
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 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.346	516448.0
2	DLD Change Limit	82551	67	2.373	34787.6
3	Display Results	67	67	0.016	4187.5
	(SQL Overall)	178691	67	2.735	65334.9