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

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

65 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
chocking	20	40	1101	(None)
checking	20	37	920	1	checking
choking	17	39	1194	1	cho_king
chucking	20	37	950	1	chucking
clocking	17	43	1241	1	clocking
cocking	16	36	1998	1	c_ocking
crocking	17	43	1344	1	crocking
hocking	17	34	1724	1	_hocking
shocking	18	43	1154	1	shocking
blocking	17	45	1057	2	blocking
chalking	18	33	1006	2	chalking
charking	18	35	1261	2	charking
cheeking	18	34	908	2	cheeking
chinking	18	32	1089	2	chinking
chirking	18	33	938	2	chirking
choiring	14	27	979	2	choiring
chomping	18	33	988	2	chomping
choosing	14	20	1013	2	choosing
chopping	18	37	1026	2	chopping
chording	15	4	1015	2	chording
choring	13	36	1766	2	cho_ring
chousing	14	25	942	2	chousing
chowing	16	44	1277	2	cho_wing
chowsing	17	21	734	2	chowsing
chuckling	21	4	419	2	chuckling
chunking	18	32	805	2	chunking
clacking	17	33	1349	2	clacking
clicking	17	36	1098	2	clicking
cloaking	15	29	971	2	cloaking
clonking	15	38	1015	2	clonking
clucking	17	42	999	2	clucking
cockling	17	23	1039	2	c_ockling
coking	13	45	2388	2	c_o_king
conking	14	36	1845	2	c_onking
cooking	14	38	1897	2	c_ooking
corking	14	30	1882	2	c_orking
cracking	17	40	1390	2	cracking
cricking	17	34	1265	2	cricking
croaking	15	37	1216	2	croaking
crooking	15	36	1134	2	crooking
docking	15	36	1501	2	_docking
flocking	18	34	1087	2	flocking
frocking	18	30	957	2	frocking
hacking	17	37	2061	2	_hacking
hoicking	18	3	605	2	_hoicking
hoking	14	44	1951	2	_ho_king
holking	15	35	1231	2	_holking
honking	15	34	1479	2	_honking
hooking	15	37	1669	2	_hooking
howking	18	36	1031	2	_howking
knocking	14	24	594	2	knocking
locking	14	37	1815	2	_locking
mocking	16	36	1445	2	_mocking
nocking	14	36	1511	2	_nocking
pocking	16	39	1676	2	_pocking
rocking	14	36	1963	2	_rocking
shacking	18	40	1408	2	shacking
shucking	18	33	943	2	shucking
smocking	17	34	910	2	smocking
socking	14	35	1860	2	_socking
stocking	15	29	1250	2	stocking
thacking	18	31	1004	2	thacking
trocking	15	36	1242	2	trocking
whacking	21	37	748	2	whacking
yocking	17	37	1237	2	_yocking

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	121059	0.390	458182.1
2	DLD Change Limit	121059	65	3.203	37795.5
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	3.609	49512.6