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

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

98 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
chunk	14	48	1238	(None)
chink	14	53	2159	1	chink
chuck	16	48	1487	1	chuck
chunks	15	42	1033	1	chunks
chunky	18	46	827	1	chunky
clunk	11	42	1508	1	clunk
hunk	11	60	2954	1	_hunk
thunk	12	49	1185	1	thunk
bohunk	15	3	374	2	bohunk
bunk	10	57	3135	2	_bunk
caulk	11	53	1545	2	caulk
chalk	14	48	1460	2	chalk
chang	11	54	1856	2	chang
chant	10	59	3269	2	chant
chark	14	42	2271	2	chark
chaunt	11	6	1349	2	chaunt
check	16	47	1471	2	check
cheek	14	51	1571	2	cheek
chick	16	54	1913	2	chick
chin	9	69	3474	2	chin_
china	10	50	2248	2	china
chine	10	52	3172	2	chine
chinks	15	58	1757	2	chinks
chinky	18	56	1054	2	chinky
chino	10	58	2331	2	chino
chins	10	56	3146	2	chins
chirk	14	45	1618	2	chirk
chock	16	43	1661	2	chock
chon	9	66	2779	2	chon_
chook	14	60	1504	2	chook
chub	11	55	1641	2	chu_b
chubs	12	54	1262	2	chubs
chucks	17	48	1293	2	chucks
chucky	20	41	800	2	chucky
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
chunked	17	42	821	2	chunked
churl	10	59	1388	2	churl
churn	10	51	1310	2	churn
churns	11	49	1023	2	churns
churr	10	45	1285	2	churr
chute	10	43	1646	2	chute
clank	11	47	1952	2	clank
clink	11	53	2004	2	clink
clonk	11	44	1744	2	clonk
cluck	13	49	1489	2	cluck
clung	8	60	1360	2	clung
clunks	12	48	1101	2	clunks
clunky	15	44	789	2	clunky
cohune	11	8	942	2	cohune
conk	10	65	3144	2	c_onk
count	7	49	3205	2	count
crank	11	48	1961	2	crank
cruck	13	56	1532	2	cruck
cunt	6	62	4367	2	c_unt
cusk	10	55	2163	2	c_usk
drunk	10	54	984	2	drunk
dunk	9	62	2857	2	_dunk
flunk	12	50	1438	2	flunk
funk	11	58	2562	2	_funk
gunk	9	54	2357	2	_gunk
hank	11	51	3414	2	_hank
honk	11	69	3119	2	_honk
huck	13	59	2763	2	_huck
hulk	11	53	2161	2	_hulk
hun	6	58	4471	2	_hun_
hung	8	61	2635	2	_hung
hunh	10	63	2373	2	_hunh
hunks	12	53	2145	2	_hunks
hunky	15	54	1773	2	_hunky
huns	7	61	3693	2	_huns
hunt	7	64	4549	2	_hunt
husk	11	60	2195	2	_husk
junk	15	51	2103	2	_junk
lunk	8	60	3072	2	_lunk
plunk	11	45	1440	2	plunk
punk	10	57	2997	2	_punk
shank	12	54	2219	2	shank
shrunk	13	35	706	2	shrunk
shuck	14	43	1453	2	shuck
shun	7	51	2277	2	shun_
shuns	8	50	1814	2	shuns
shunt	8	52	2651	2	shunt
skunk	8	50	1176	2	skunk
slunk	9	50	1630	2	slunk
spunk	11	45	1340	2	spunk
stunk	9	46	1629	2	stunk
sunk	8	50	3181	2	_sunk
thank	12	58	1780	2	thank
think	12	50	1880	2	think
thunks	13	45	903	2	thunks
trunk	9	47	1304	2	trunk

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.623	286823.4
2	DLD Change Limit	53800	98	2.173	24758.4
3	Display Results	98	98	0.030	3266.7
	(SQL Overall)	178691	98	2.826	63231.1