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

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

45 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
hoicking	18	3	605	(None)
hocking	17	34	1724	1	ho_cking
boinking	15	37	842	2	boinking
bricking	17	39	1140	2	bricking
chocking	20	40	1101	2	cho_cking
clicking	17	36	1098	2	clicking
cocking	16	36	1998	2	co_cking
cricking	17	34	1265	2	cricking
dicking	15	36	1761	2	_dicking
docking	15	36	1501	2	do_cking
flicking	18	41	1004	2	flicking
hacking	17	37	2061	2	h_acking
hiking	14	36	1710	2	h_i_king
hoising	11	34	1441	2	hoi_sing
hoisting	12	36	1090	2	hoisting
hoking	14	44	1951	2	ho__king
holking	15	35	1231	2	ho_lking
honking	15	34	1479	2	ho_nking
hooking	15	37	1669	2	ho_oking
hotching	17	30	931	2	hotching
howking	18	36	1031	2	ho_wking
kicking	13	33	1402	2	_kicking
licking	14	41	1828	2	_licking
locking	14	37	1815	2	lo_cking
mocking	16	36	1445	2	mo_cking
nicking	14	35	1632	2	_nicking
nocking	14	36	1511	2	no_cking
oinking	12	37	1471	2	_oinking
picking	16	34	1833	2	_picking
pocking	16	39	1676	2	po_cking
pricking	17	32	1260	2	pricking
ricking	14	39	2023	2	_ricking
rocking	14	36	1963	2	ro_cking
shocking	18	43	1153	2	sho_cking
sicking	14	37	2017	2	_sicking
slicking	15	37	1259	2	slicking
snicking	15	36	1023	2	snicking
socking	14	35	1860	2	so_cking
sticking	15	35	1346	2	sticking
ticking	14	32	1875	2	_ticking
tricking	15	27	1451	2	tricking
voicing	13	27	908	2	voic_ing
wicking	17	34	1477	2	_wicking
wricking	18	34	949	2	wricking
yocking	17	37	1237	2	yo_cking

Search took 5 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	121059	0.143	1249587.4
2	DLD Change Limit	121059	45	4.140	29241.3
3	Display Results	45	45	0.013	3461.5
	(SQL Overall)	178691	45	4.296	41594.7