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

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

98 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
konked	10	40	1058	(None)
bonked	13	55	1731	1	bonked
conked	13	50	1911	1	conked
honked	14	45	1791	1	honked
kinked	10	40	1475	1	kinked
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
clonked	14	42	956	2	clonked
cocked	15	50	2256	2	cocked
coked	12	47	3069	2	co_ked
coned	8	60	4005	2	con_ed
conker	12	47	2155	2	conker
conned	9	51	1970	2	conned
cooked	13	59	2136	2	cooked
corked	13	50	2078	2	corked
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
kecked	12	51	1317	2	kecked
keeked	10	48	1012	2	keeked
kenned	11	44	1127	2	kenned
kicked	12	44	1594	2	kicked
kinged	12	42	1529	2	kinged
kneed	10	46	1205	2	k_need
knocked	13	23	630	2	knocked
konk	7	93	2061	2	konk__
konks	8	49	1711	2	konk_s
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
skanked	11	33	810	2	skanked
skinked	11	33	901	2	skinked
skunked	11	31	619	2	skunked
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.343	520965.0
2	DLD Change Limit	82551	98	2.436	33887.9
3	Display Results	98	98	0.033	2969.7
	(SQL Overall)	178691	98	2.812	63545.9