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

Here are the results of your fuzzy-string dictionary search for “conked” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

178 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
conked	13	50	1911	(None)
bonked	13	55	1731	1	bonked
clonked	14	42	956	1	clonked
cocked	15	50	2256	1	cocked
coked	12	47	3069	1	co_ked
coned	8	60	4005	1	con_ed
conker	12	47	2155	1	conker
conned	9	51	1970	1	conned
cooked	13	59	2136	1	cooked
corked	13	50	2078	1	corked
honked	14	45	1791	1	honked
konked	10	40	1058	1	konked
zonked	20	42	947	1	zonked
banked	13	50	2144	2	banked
boinked	14	45	704	2	boinked
bonded	10	47	1995	2	bonded
boned	8	51	3324	2	bon_ed
bonged	10	57	1960	2	bonged
booked	13	53	1950	2	booked
borked	13	51	1729	2	borked
bunked	13	51	1837	2	bunked
caked	12	61	2862	2	c_aked
calked	13	46	1740	2	calked
caned	8	58	3809	2	can_ed
canker	12	44	2252	2	canker
canned	9	50	2206	2	canned
canoed	9	46	1896	2	canoed
canted	9	48	2578	2	canted
carked	13	40	2482	2	carked
casked	13	48	1551	2	casked
censed	9	40	1632	2	censed
chinked	17	40	1102	2	chinked
chocked	19	44	1161	2	chocked
choked	16	49	1479	2	choked
chunked	17	42	821	2	chunked
clanked	14	38	1225	2	clanked
clinked	14	40	1164	2	clinked
cloaked	14	36	854	2	cloaked
clocked	16	41	1283	2	clocked
cloned	9	45	1880	2	clon_ed
clunked	14	43	957	2	clunked
coaled	9	50	2271	2	coaled
coated	9	49	2704	2	coated
coaxed	16	56	1251	2	coaxed
cocker	14	43	2039	2	cocker
cockled	16	37	1082	2	cockled
codded	11	45	1530	2	codded
coded	9	54	3318	2	co_ded
coed	7	71	4054	2	co__ed
cogged	11	64	1661	2	cogged
coifed	12	41	1306	2	coifed
coiled	9	51	2394	2	coiled
coined	9	45	2360	2	coined
coke	10	70	3838	2	co_ke_
cokes	11	55	3719	2	co_kes
coled	8	55	4076	2	co_led
combed	13	55	1654	2	combed
comped	13	59	1987	2	comped
concede	12	3	1010	2	concede
cone	6	72	5696	2	con_e_
cones	7	64	5742	2	con_es
coney	10	59	3288	2	con_ey
confer	11	40	1868	2	confer
congaed	11	39	974	2	congaed
conge	8	52	2759	2	conge_
congee	9	60	2447	2	congee
congeed	11	32	1231	2	congeed
conger	9	50	2427	2	conger
conges	9	49	2817	2	conges
conies	8	43	3859	2	conies
conk	10	65	3144	2	conk__
conkers	13	37	2104	2	conkers
conks	11	55	2570	2	conk_s
conky	14	58	1874	2	conk_y
conner	8	44	2396	2	conner
conoid	9	8	1888	2	conoid
conte	7	66	3320	2	conte_
contend	10	35	1189	2	contend
contes	8	44	3291	2	contes
convex	18	36	774	2	convex
convey	14	46	1022	2	convey
convoked	18	23	616	2	convoked
cooed	8	45	3434	2	co_oed
cooeed	9	59	1786	2	cooeed
cooker	12	47	2245	2	cooker
cookey	15	54	1433	2	cookey
cooled	9	52	2459	2	cooled
cooped	11	48	2160	2	cooped
coped	10	50	3684	2	co_ped
copied	11	46	1856	2	copied
copped	13	52	2125	2	copped
corded	10	59	2335	2	corded
cored	8	50	4422	2	co_red
corker	12	47	2085	2	corker
corned	9	52	2452	2	corned
cornfed	13	3	738	2	cornfed
coshed	12	42	1754	2	coshed
cosied	9	48	1988	2	cosied
costed	9	56	2311	2	costed
coted	8	50	3385	2	co_ted
counted	10	38	1580	2	counted
couped	11	50	1931	2	couped
coved	11	50	2737	2	co_ved
cowed	11	56	3785	2	co_wed
cowled	12	52	1839	2	cowled
coxed	15	43	2281	2	co_xed
coyed	11	46	2380	2	co_yed
cozied	18	41	1215	2	cozied
cranked	14	38	1284	2	cranked
croaked	14	37	1053	2	croaked
crocked	16	40	1443	2	crocked
crooked	14	39	1094	2	crooked
dinked	12	48	1835	2	dinked
docked	14	50	1833	2	docked
donkey	14	44	973	2	donkey
donned	8	50	1574	2	donned
dunked	12	43	1528	2	dunked
finked	14	42	1462	2	finked
fonded	11	57	1704	2	fonded
forked	14	52	1714	2	forked
funked	14	42	1411	2	funked
gonged	9	71	1591	2	gonged
hanked	14	42	2060	2	hanked
hocked	16	55	2130	2	hocked
hoked	13	53	2699	2	ho_ked
holked	14	49	1366	2	holked
honed	9	53	3226	2	hon_ed
honied	10	48	1839	2	honied
honker	13	41	1746	2	honker
honkey	16	51	1382	2	honkey
hooked	14	53	2055	2	hooked
howked	17	73	1234	2	howked
inked	10	42	1852	2	_inked
jinked	18	40	1314	2	jinked
joked	17	52	1791	2	jo_ked
jouked	18	56	815	2	jouked
junked	18	43	1169	2	junked
kinked	10	40	1475	2	kinked
linked	11	45	1821	2	linked
locked	13	49	2166	2	locked
longed	8	71	2137	2	longed
looked	11	47	1707	2	looked
mocked	15	47	1661	2	mocked
monied	9	43	1946	2	monied
monkey	15	37	1059	2	monkey
nocked	13	46	1738	2	nocked
nonsked	12	3	623	2	nonsked
oinked	11	42	1328	2	oinked
pinked	13	48	1988	2	pinked
plonked	14	34	810	2	plonked
pocked	15	48	1898	2	pocked
poked	12	54	2539	2	po_ked
ponced	11	43	1481	2	ponced
ponded	10	52	1877	2	ponded
ponged	10	56	1935	2	ponged
ponied	9	49	2070	2	ponied
porked	13	47	1762	2	porked
ranked	11	46	2074	2	ranked
rocked	13	50	2232	2	rocked
rooked	11	49	1814	2	rooked
sconced	12	35	917	2	sconced
soaked	11	47	1759	2	soaked
socked	13	47	2150	2	socked
tanked	11	39	1929	2	tanked
toked	10	56	2649	2	to_ked
toned	6	54	3534	2	ton_ed
tonged	8	65	1890	2	tonged
wanked	14	45	1715	2	wanked
winked	14	40	1860	2	winked
wonned	10	40	1206	2	wonned
wonted	10	32	1328	2	wonted
worked	14	53	1470	2	worked
yanked	14	43	1224	2	yanked
yocked	16	41	1442	2	yocked
yoked	13	48	2162	2	yo_ked
yolked	14	36	715	2	yolked
yonker	13	41	1085	2	yonker
zoned	15	40	2026	2	zon_ed

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.326	548131.9
2	DLD Change Limit	82551	178	2.250	36689.3
3	Display Results	178	178	0.046	3869.6
	(SQL Overall)	178691	178	2.622	68150.6