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

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

87 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
check	16	47	1471	(None)
checks	17	49	1270	1	checks
cheek	14	51	1571	1	cheek
chick	16	54	1913	1	chick
chock	16	43	1661	1	chock
chuck	16	48	1487	1	chuck
heck	13	58	2649	1	_heck
beck	12	62	2657	2	_beck
caeca	9	39	1513	2	caeca
ceca	8	48	2078	2	c_eca
chalk	14	48	1460	2	chalk
chark	14	42	2271	2	chark
cheap	12	69	1594	2	cheap
cheat	10	57	3245	2	cheat
checked	19	37	1002	2	checked
checker	18	32	953	2	checker
checkup	20	4	332	2	checkup
cheeks	15	47	1278	2	cheeks
cheeky	18	44	861	2	cheeky
cheep	12	54	1650	2	cheep
cheer	10	54	2038	2	cheer
chef	12	51	2562	2	che_f
chefs	13	62	1466	2	chefs
chela	10	39	1680	2	chela
chemo	12	3	1363	2	chemo
chert	10	52	3210	2	chert
chess	10	50	1692	2	chess
chest	10	49	2614	2	chest
cheth	13	50	1382	2	cheth
chevy	16	47	999	2	chevy
chew	12	66	2213	2	che_w
chews	13	54	1851	2	chews
chewy	16	50	1190	2	chewy
chez	18	45	1902	2	che_z
chic	11	59	2520	2	chic_
chica	12	58	1826	2	chica
chicks	17	53	1759	2	chicks
chico	12	42	1825	2	chico
chics	12	39	2094	2	chics
chink	14	53	2159	2	chink
chirk	14	45	1618	2	chirk
chocks	17	48	1531	2	chocks
chook	14	60	1504	2	chook
chucks	17	48	1293	2	chucks
chucky	20	41	800	2	chucky
chunk	14	48	1238	2	chunk
clack	13	47	2017	2	clack
cleek	11	55	1491	2	cleek
clerk	11	58	1245	2	clerk
click	13	52	1795	2	click
clock	13	49	1798	2	clock
cluck	13	49	1489	2	cluck
cock	12	63	3290	2	c_ock
copeck	16	3	694	2	copeck
crack	13	41	2053	2	crack
creak	11	54	1843	2	creak
creek	11	49	1739	2	creek
crick	13	51	1875	2	crick
crock	13	59	2199	2	crock
cruck	13	56	1532	2	cruck
deck	11	58	2775	2	_deck
dreck	12	48	1280	2	dreck
feck	13	49	2343	2	_feck
fleck	14	82	1359	2	fleck
geck	11	57	2199	2	_geck
hack	13	51	3454	2	_hack
hecks	14	52	2065	2	_hecks
hick	13	55	3031	2	_hick
hock	13	60	3130	2	_hock
huck	13	59	2763	2	_huck
keck	9	49	2072	2	_keck
neck	10	54	2366	2	_neck
peck	12	57	3068	2	_peck
recheck	18	3	561	2	recheck
reck	10	61	3056	2	_reck
shack	14	53	2175	2	shack
sheik	12	25	1466	2	sheik
shock	14	49	1703	2	shock
shuck	14	43	1453	2	shuck
sneck	11	47	1366	2	sneck
speck	13	51	1565	2	speck
thack	14	49	1517	2	thack
theca	10	33	1145	2	theca
thick	14	56	1335	2	thick
whack	17	48	1302	2	whack
whelk	15	43	1106	2	whelk
wreck	14	46	1104	2	wreck

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	53800	0.313	570897.8
2	DLD Change Limit	53800	87	1.656	32487.9
3	Display Results	87	87	0.013	6692.3
	(SQL Overall)	178691	87	1.982	90156.9