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

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

77 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
clucks	14	45	1207	(None)
chucks	17	48	1293	1	chucks
clacks	14	45	1634	1	clacks
clicks	14	53	1511	1	clicks
clocks	14	49	1623	1	clocks
cluck	13	49	1489	1	cluck_
clunks	12	48	1101	1	clunks
crucks	14	44	1258	1	crucks
lucks	11	57	2356	1	_lucks
plucks	14	37	973	1	plucks
amucks	14	6	600	2	amucks
blacks	14	49	1495	2	blacks
blocks	14	45	1394	2	blocks
bucks	13	48	2429	2	_bucks
caucus	10	3	961	2	caucus
caulks	12	56	1186	2	caulks
checks	17	49	1270	2	checks
chicks	17	53	1759	2	chicks
chocks	17	48	1531	2	chocks
chuck	16	48	1487	2	chuck_
chucky	20	41	800	2	chucky
chunks	15	42	1033	2	chunks
clachs	13	35	1132	2	clachs
clack	13	47	2017	2	clack_
clanks	12	46	1518	2	clanks
cleeks	12	50	1054	2	cleeks
clerks	12	45	884	2	clerks
click	13	52	1795	2	click_
clinks	12	58	1506	2	clinks
cloaks	12	44	1126	2	cloaks
clock	13	49	1798	2	clock_
clonks	12	50	1347	2	clonks
clubs	9	54	1510	2	clu_bs
clucked	16	38	1013	2	clucked
clues	7	46	2303	2	clu_es
clumps	12	153	1464	2	clumps
clunk	11	42	1508	2	clunk_
clunky	15	44	789	2	clunky
cocks	13	52	2716	2	c_ocks
cracks	14	48	1700	2	cracks
cricks	14	43	1605	2	cricks
crocks	14	51	1842	2	crocks
cruces	10	51	1754	2	cruces
cruck	13	56	1532	2	cruck_
cusks	11	49	1605	2	c_usks
ducks	12	48	2321	2	_ducks
flacks	15	41	1453	2	flacks
flecks	15	43	1080	2	flecks
flicks	15	45	1299	2	flicks
flocks	15	47	1353	2	flocks
flunks	13	46	986	2	flunks
fucks	14	44	1925	2	_fucks
gucks	12	39	1730	2	_gucks
hucks	14	43	2217	2	_hucks
klicks	11	46	872	2	klicks
lacks	11	61	2920	2	_lacks
licks	11	53	2539	2	_licks
locks	11	51	2692	2	_locks
luces	7	55	2843	2	_luces
luck	10	53	2982	2	_luck_
lucky	14	55	1501	2	_lucky
lunks	9	48	2245	2	_lunks
lurks	9	52	1874	2	_lurks
mucks	13	46	2264	2	_mucks
placks	14	44	1415	2	placks
pluck	13	42	1230	2	pluck_
plucky	17	40	658	2	plucky
plunks	12	47	1116	2	plunks
pucks	13	43	2210	2	_pucks
rucks	11	44	2205	2	_rucks
shucks	15	40	1041	2	shucks
slacks	12	44	1653	2	slacks
slicks	12	48	1611	2	slicks
sucks	11	45	2307	2	_sucks
trucks	12	47	1197	2	trucks
tucks	11	47	2112	2	_tucks
yucks	14	47	1719	2	_yucks

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.343	520965.0
2	DLD Change Limit	82551	77	2.203	37472.1
3	Display Results	77	77	0.033	2333.3
	(SQL Overall)	178691	77	2.579	69286.9