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

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

71 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
smacker	15	34	1058	(None)
sacker	12	51	2484	1	s_acker
slacker	13	39	1529	1	slacker
smacked	16	37	1099	1	smacked
smackers	16	31	871	1	smackers
snacker	13	31	1260	1	snacker
stacker	13	44	1626	1	stacker
backer	14	45	2552	2	_backer
blacker	15	45	1351	2	blacker
clacker	15	38	1377	2	clacker
cracker	15	31	1417	2	cracker
dacker	13	49	2075	2	_dacker
hacker	15	48	2269	2	_hacker
jacker	19	44	1758	2	_jacker
knacker	12	30	791	2	knacker
lacker	12	53	2562	2	_lacker
macer	9	121	2694	2	_mac_er
maker	11	41	2781	2	_ma_ker
marker	12	44	2039	2	_marker
masker	12	44	1610	2	_masker
mocker	14	33	1544	2	_mocker
mucker	14	38	1639	2	_mucker
packer	14	42	2340	2	_packer
racker	12	48	2455	2	_racker
sacked	13	55	2521	2	s_acked
sackers	13	38	2022	2	s_ackers
saker	9	51	3202	2	s_a_ker
shacked	17	40	1539	2	shacked
shackler	17	31	797	2	shackler
shaker	13	43	1946	2	sha_ker
sharker	14	43	1381	2	sharker
shicker	16	39	1482	2	shicker
shocker	16	34	1142	2	shocker
shucker	16	37	1010	2	shucker
sicker	12	40	2390	2	s_icker
skanker	10	26	848	2	skanker
slacked	14	38	1545	2	slacked
slacken	13	39	993	2	slacken
slackers	14	38	1274	2	slackers
slaker	10	42	1927	2	sla_ker
slicker	13	33	1453	2	slicker
smack	13	46	1545	2	smack__
smacks	14	41	1232	2	smack_s
smaller	9	34	1033	2	smaller
smarter	9	41	1313	2	smarter
smasher	12	39	1101	2	smasher
smatter	9	36	1333	2	smatter
smirker	13	32	742	2	smirker
smocked	16	39	822	2	smocked
smoker	12	43	1169	2	sm_oker
snacked	14	40	1311	2	snacked
snackers	14	30	1022	2	snackers
snicker	13	30	1267	2	snicker
soaker	10	57	1753	2	soa_ker
spacer	10	49	1779	2	spac_er
spacier	11	40	1163	2	spacier
spanker	13	36	1235	2	spanker
sparker	13	39	1435	2	sparker
stacked	14	34	1612	2	stacked
stackers	14	34	1356	2	stackers
stalker	11	39	1225	2	stalker
starker	11	41	1469	2	starker
sticker	13	35	1588	2	sticker
stocker	13	37	1308	2	stocker
sucker	12	41	2066	2	s_ucker
swacked	17	31	1052	2	swacked
swanker	14	36	948	2	swanker
tacker	12	42	2450	2	_tacker
tracker	13	35	1517	2	tracker
wacker	15	49	2012	2	_wacker
whacker	19	36	850	2	whacker

Search took 8 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	107671	0.140	1276364.3
2	DLD Change Limit	107671	71	6.986	15412.4
3	Display Results	71	71	0.046	1543.5
	(SQL Overall)	178691	71	7.172	24915.1