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

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

90 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
chuck	16	48	1487	(None)
check	16	47	1471	1	check
chick	16	54	1913	1	chick
chock	16	43	1661	1	chock
chucks	17	48	1293	1	chucks
chucky	20	41	800	1	chucky
chunk	14	48	1238	1	chunk
cluck	13	49	1489	1	cluck
cruck	13	56	1532	1	cruck
huck	13	59	2763	1	_huck
shuck	14	43	1453	1	shuck
amuck	13	8	956	2	amuck
buck	12	51	2990	2	_buck
caulk	11	53	1545	2	caulk
chalk	14	48	1460	2	chalk
chark	14	42	2271	2	chark
checks	17	49	1270	2	checks
cheek	14	51	1571	2	cheek
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
chub	11	55	1641	2	chu_b
chubs	12	54	1262	2	chubs
chucked	19	46	973	2	chucked
chuckle	18	3	644	2	chuckle
chufa	13	48	911	2	chufa
chuff	16	48	1249	2	chuff
chug	10	59	1411	2	chu_g
chugs	11	55	1194	2	chugs
chukka	14	3	301	2	chukka
chum	11	63	1800	2	chu_m
chump	14	53	1544	2	chump
chums	12	50	1583	2	chums
chunks	15	42	1033	2	chunks
chunky	18	46	827	2	chunky
church	16	3	648	2	church
churl	10	59	1388	2	churl
churn	10	51	1310	2	churn
churr	10	45	1285	2	churr
chute	10	43	1646	2	chute
clack	13	47	2017	2	clack
click	13	52	1795	2	click
clock	13	49	1798	2	clock
clucks	14	45	1207	2	clucks
clunk	11	42	1508	2	clunk
cock	12	63	3290	2	c_ock
couch	12	53	2011	2	couch
crack	13	41	2053	2	crack
crick	13	51	1875	2	crick
crock	13	59	2199	2	crock
crucks	14	44	1258	2	crucks
cusk	10	55	2163	2	c_usk
duck	11	59	2917	2	_duck
fuck	13	49	2463	2	_fuck
guck	11	49	2253	2	_guck
hack	13	51	3454	2	_hack
heck	13	58	2649	2	_heck
hick	13	55	3030	2	_hick
hock	13	60	3130	2	_hock
hucks	14	43	2217	2	_hucks
hulk	11	53	2161	2	_hulk
hunk	11	60	2954	2	_hunk
husk	11	60	2195	2	_husk
luck	10	53	2982	2	_luck
muck	12	57	2785	2	_muck
pluck	13	42	1230	2	pluck
puck	12	49	2794	2	_puck
ruck	10	47	2833	2	_ruck
schmuck	20	4	304	2	schmuck
shack	14	53	2175	2	shack
shmuck	17	3	424	2	shmuck
shock	14	49	1703	2	shock
shucks	15	40	1041	2	shucks
snuck	11	44	1191	2	snuck
stuck	11	45	1577	2	stuck
suck	10	61	3173	2	_suck
thack	14	49	1517	2	thack
thick	14	56	1335	2	thick
thunk	12	49	1185	2	thunk
truck	11	61	1546	2	truck
tuck	10	46	2657	2	_tuck
upchuck	20	4	194	2	upchuck
whack	17	48	1302	2	whack
yuck	13	64	2353	2	_yuck

Search took 2 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	90	1.466	36698.5
3	Display Results	90	90	0.033	2727.3
	(SQL Overall)	178691	90	1.812	98615.3