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

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

50 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
hoicked	17	3	596	(None)
hocked	16	55	2130	1	ho_cked
boinked	14	45	704	2	boinked
bricked	16	43	1206	2	bricked
chocked	19	44	1161	2	cho_cked
clicked	16	41	1245	2	clicked
cocked	15	50	2256	2	co_cked
cricked	16	48	1428	2	cricked
dicked	14	49	2086	2	_dicked
docked	14	50	1833	2	do_cked
flicked	17	46	1067	2	flicked
hacked	16	49	2351	2	h_acked
hickey	18	50	1199	2	h_ickey
hiked	13	59	1920	2	h_i_ked
hocker	15	51	1856	2	ho_cker
hockey	18	48	1315	2	ho_ckey
hoick	14	52	1068	2	hoick__
hoicks	15	37	828	2	hoick_s
hoised	10	51	1743	2	hoi_sed
hoisted	11	34	1129	2	hoisted
hoked	13	53	2699	2	ho__ked
holked	14	49	1366	2	ho_lked
honked	14	45	1791	2	ho_nked
hooked	14	53	2055	2	ho_oked
hotched	16	36	1092	2	hotched
howked	17	73	1234	2	ho_wked
kicked	12	44	1594	2	_kicked
licked	13	46	2156	2	_licked
locked	13	49	2166	2	lo_cked
mocked	15	47	1661	2	mo_cked
nicked	13	50	1968	2	_nicked
nocked	13	46	1738	2	no_cked
oinked	11	42	1328	2	_oinked
picked	15	44	2131	2	_picked
pocked	15	48	1898	2	po_cked
pricked	16	46	1383	2	pricked
ricked	13	65	2362	2	_ricked
rocked	13	50	2232	2	ro_cked
shocked	17	46	1181	2	sho_cked
sicked	13	45	2440	2	_sicked
slicked	14	44	1384	2	slicked
snicked	14	38	1163	2	snicked
socked	13	47	2150	2	so_cked
sticked	14	41	1463	2	sticked
ticked	13	47	2052	2	_ticked
tricked	14	40	1616	2	tricked
voiced	12	39	1011	2	voic_ed
wicked	16	43	1741	2	_wicked
wricked	17	49	1019	2	wricked
yocked	16	41	1442	2	yo_cked

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	107671	0.393	454684.5
2	DLD Change Limit	107671	50	3.466	31064.9
3	Display Results	50	50	0.016	3125.0
	(SQL Overall)	178691	50	3.875	46113.8