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

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

64 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
donkey	14	44	973	(None)
dinkey	14	48	1276	1	dinkey
donkeys	15	42	666	1	donkeys
honkey	16	51	1382	1	honkey
monkey	15	37	1059	1	monkey
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
danker	11	43	1966	2	danker
dankly	14	41	946	2	dankly
darkey	14	52	1242	2	darkey
dickey	16	59	1352	2	dickey
dikey	13	51	1642	2	d_ikey
dingey	11	49	1404	2	dingey
dinked	12	48	1835	2	dinked
dinkeys	15	50	726	2	dinkeys
dinkly	14	43	1108	2	dinkly
dinky	13	58	1937	2	dink_y
docked	14	50	1833	2	docked
docker	13	44	1765	2	docker
docket	13	47	2117	2	docket
dogey	10	57	1951	2	do_gey
done	5	57	4791	2	don_e_
donee	6	69	3101	2	don_ee
donees	7	45	1949	2	donees
donne	6	55	2046	2	donne_
donned	8	50	1574	2	donned
donnee	7	43	1706	2	donnee
donsy	9	64	1468	2	don_sy
donzel	16	3	631	2	donzel
dopey	11	60	2035	2	do_pey
dorky	13	55	1874	2	dork_y
dovekey	18	5	278	2	dovekey
doyley	13	48	728	2	doyley
dunked	12	43	1528	2	dunked
dunker	11	36	1646	2	dunker
dykey	16	60	867	2	d_ykey
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
money	10	48	2684	2	mon_ey
monkery	16	31	744	2	monkery
monkeys	16	40	742	2	monkeys
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 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	64	2.390	34540.2
3	Display Results	64	64	0.016	4000.0
	(SQL Overall)	178691	64	2.516	71021.9