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

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

100 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
chocks	17	48	1531	(None)
checks	17	49	1270	1	checks
chicks	17	53	1759	1	chicks
chock	16	43	1661	1	chock_
chooks	15	53	1279	1	chooks
chucks	17	48	1293	1	chucks
clocks	14	49	1623	1	clocks
cocks	13	52	2716	1	c_ocks
crocks	14	51	1842	1	crocks
hocks	14	49	2549	1	_hocks
shocks	15	44	1458	1	shocks
blocks	14	45	1394	2	blocks
bocks	13	45	2657	2	_bocks
brocks	14	52	1415	2	brocks
chalks	15	54	1214	2	chalks
charks	15	52	1970	2	charks
check	16	47	1471	2	check_
cheeks	15	47	1278	2	cheeks
chicas	13	59	1647	2	chicas
chick	16	54	1913	2	chick_
chicos	13	46	1483	2	chicos
chics	12	39	2094	2	chic_s
chinks	15	58	1757	2	chinks
chirks	15	54	1484	2	chirks
chocked	19	44	1161	2	chocked
choices	14	20	1061	2	choices
choirs	11	49	1188	2	choirs
choke	14	51	1802	2	cho_ke
chokes	15	49	1738	2	chokes
choky	17	57	1122	2	cho_ky
cholas	11	48	1800	2	cholas
cholos	11	47	1685	2	cholos
chomps	15	51	1222	2	chomps
chook	14	60	1504	2	chook_
chops	12	50	1987	2	cho_ps
chords	12	52	1463	2	chords
chores	11	48	2802	2	chores
chorus	11	50	1477	2	chorus
choses	11	58	2513	2	choses
chotts	11	36	1099	2	chotts
chows	13	56	1820	2	cho_ws
chuck	16	48	1487	2	chuck_
chucky	20	41	800	2	chucky
chunks	15	42	1033	2	chunks
clacks	14	45	1634	2	clacks
clicks	14	53	1511	2	clicks
cloaks	12	44	1126	2	cloaks
clock	13	49	1798	2	clock_
clonks	12	50	1347	2	clonks
clucks	14	45	1207	2	clucks
cocas	9	59	2657	2	c_ocas
cock	12	63	3290	2	c_ock_
cocky	16	42	1593	2	c_ocky
cocos	9	56	2469	2	c_ocos
conks	11	55	2570	2	c_onks
cooks	11	54	2914	2	c_ooks
corks	11	60	2827	2	c_orks
cracks	14	48	1700	2	cracks
cricks	14	43	1605	2	cricks
croaks	12	58	1298	2	croaks
crock	13	59	2199	2	crock_
crocs	9	57	2243	2	croc_s
crocus	10	48	1317	2	crocus
crooks	12	49	1441	2	crooks
crucks	14	44	1258	2	crucks
docks	12	60	2231	2	_docks
flocks	15	47	1353	2	flocks
frocks	15	41	1121	2	frocks
hacks	14	49	2871	2	_hacks
hecks	14	52	2065	2	_hecks
hicks	14	53	2217	2	_hicks
hock	13	60	3130	2	_hock_
hocus	10	47	1520	2	_hocus
hoicks	15	37	828	2	_hoicks
holks	12	47	2056	2	_holks
honks	12	51	2452	2	_honks
hooks	12	50	2712	2	_hooks
howks	15	50	1685	2	_howks
hucks	14	43	2217	2	_hucks
jocks	18	51	1808	2	_jocks
knocks	11	39	744	2	knocks
locks	11	51	2692	2	_locks
mocks	13	50	2382	2	_mocks
nocks	11	51	2101	2	_nocks
pocks	13	50	2296	2	_pocks
rocks	11	46	2641	2	_rocks
schlocks	19	24	569	2	schlocks
shacks	15	48	1756	2	shacks
shlocks	16	31	718	2	shlocks
shock	14	49	1703	2	shock_
shooks	13	45	1563	2	shooks
shucks	15	40	1041	2	shucks
smocks	14	57	1001	2	smocks
socks	11	49	2608	2	_socks
stocks	12	47	1563	2	stocks
thacks	15	43	1192	2	thacks
thicks	15	45	1199	2	thicks
trocks	12	36	1463	2	trocks
whacks	18	46	1048	2	whacks
yocks	14	44	1837	2	_yocks

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.346	516448.0
2	DLD Change Limit	82551	100	2.436	33887.9
3	Display Results	100	100	0.030	3333.3
	(SQL Overall)	178691	100	2.812	63545.9