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

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

93 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
shucks	15	40	1041	(None)
chucks	17	48	1293	1	chucks
hucks	14	43	2217	1	_hucks
shacks	15	48	1756	1	shacks
shmucks	18	3	394	1	shmucks
shocks	15	44	1458	1	shocks
shuck	14	43	1453	1	shuck_
sucks	11	45	2307	1	s_ucks
amucks	14	6	600	2	amucks
bucks	13	48	2429	2	_bucks
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
clucks	14	45	1207	2	clucks
crucks	14	44	1258	2	crucks
ducks	12	48	2321	2	_ducks
fucks	14	44	1925	2	_fucks
gucks	12	39	1730	2	_gucks
hacks	14	49	2871	2	_hacks
hecks	14	52	2065	2	_hecks
hicks	14	53	2217	2	_hicks
hocks	14	49	2549	2	_hocks
huck	13	59	2763	2	_huck_
hulks	12	57	1548	2	_hulks
hunks	12	53	2145	2	_hunks
husks	12	50	1545	2	_husks
lucks	11	57	2356	2	_lucks
mucks	13	46	2264	2	_mucks
plucks	14	37	973	2	plucks
pucks	13	43	2210	2	_pucks
rucks	11	44	2205	2	_rucks
sacks	11	42	2887	2	s_acks
sauces	8	49	1950	2	sauces
sauchs	11	51	1223	2	sauchs
schmucks	21	4	276	2	schmucks
sculks	12	36	1026	2	sculks
shack	14	53	2175	2	shack_
shacko	15	38	1011	2	shacko
shackos	16	42	902	2	shackos
shanks	13	53	1558	2	shanks
sharks	13	50	1972	2	sharks
sheiks	13	25	1001	2	sheiks
sheuchs	15	23	493	2	sheuchs
shicksa	16	3	410	2	shicksa
shirks	13	48	1412	2	shirks
shlocks	16	31	718	2	shlocks
shmuck	17	3	424	2	shmuck_
shock	14	49	1703	2	shock_
shooks	13	45	1563	2	shooks
shticks	16	35	696	2	shticks
shtiks	13	29	783	2	shtiks
shucked	17	38	983	2	shucked
shucker	16	37	1010	2	shucker
shuckers	17	38	813	2	shuckers
shuls	8	53	1971	2	shu_ls
shuns	8	50	1814	2	shu_ns
shunts	9	57	1202	2	shunts
shutes	9	35	1822	2	shutes
shuts	8	56	2248	2	shu_ts
sicks	11	51	2762	2	s_icks
skulks	9	42	724	2	skulks
skunks	9	46	816	2	skunks
slacks	12	44	1653	2	slacks
slicks	12	48	1611	2	slicks
smacks	14	41	1232	2	smacks
smocks	14	57	1001	2	smocks
snacks	12	45	1455	2	snacks
snecks	12	44	1003	2	snecks
snicks	12	43	1247	2	snicks
snuck	11	44	1191	2	snuck_
socks	11	49	2608	2	s_ocks
souks	9	48	2052	2	sou_ks
specks	14	43	1270	2	specks
spicks	14	48	1499	2	spicks
spunks	12	34	933	2	spunks
stacks	12	43	1726	2	stacks
sticks	12	51	1861	2	sticks
stocks	12	47	1563	2	stocks
stuck	11	45	1577	2	stuck_
suck	10	61	3173	2	s_uck_
sucky	14	44	1550	2	s_ucky
suks	8	59	2712	2	s_u_ks
sulks	9	48	1846	2	s_ulks
thacks	15	43	1192	2	thacks
thicks	15	45	1199	2	thicks
thunks	13	45	903	2	thunks
trucks	12	47	1197	2	trucks
tucks	11	47	2112	2	_tucks
whacks	18	46	1048	2	whacks
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.360	496363.9
2	DLD Change Limit	82551	93	2.533	32590.2
3	Display Results	93	93	0.030	3100.0
	(SQL Overall)	178691	93	2.923	61132.7