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

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

99 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
smack	13	46	1545	(None)
mack	12	57	3365	1	_mack
sack	10	53	3731	1	s_ack
shack	14	53	2175	1	shack
slack	11	50	2176	1	slack
smacks	14	41	1232	1	smacks
smock	13	53	1167	1	smock
snack	11	47	1806	1	snack
stack	11	44	2169	1	stack
aback	13	48	1617	2	aback
alack	11	48	2006	2	alack
amuck	13	8	956	2	amuck
back	12	55	3576	2	_back
black	13	47	1907	2	black
clack	13	47	2017	2	clack
crack	13	41	2053	2	crack
flack	14	45	1941	2	flack
hack	13	51	3454	2	_hack
jack	17	52	2486	2	_jack
knack	10	43	1104	2	knack
kyack	13	46	826	2	kyack
lack	10	58	3768	2	_lack
mac	7	80	5393	2	_mac_
mace	8	73	4579	2	_mace
mach	11	61	3448	2	_mach
macks	13	51	2760	2	_macks
macs	8	67	4251	2	_macs
mark	10	51	3806	2	_mark
mask	10	52	2736	2	_mask
mick	12	63	3343	2	_mick
mock	12	64	2944	2	_mock
muck	12	57	2785	2	_muck
pack	12	55	3544	2	_pack
plack	13	50	1784	2	plack
quack	20	38	1250	2	quack
rack	10	62	3488	2	_rack
sac	5	74	5286	2	s_ac_
sacks	11	42	2887	2	s_acks
sacs	6	57	3907	2	s_acs
samek	11	49	1527	2	samek
sank	8	52	3683	2	s_ank
sark	8	49	3897	2	s_ark
shacko	15	38	1011	2	shacko
shacks	15	48	1756	2	shacks
shank	12	54	2219	2	shank
shark	12	62	2502	2	shark
shmuck	17	3	424	2	shmuck
shock	14	49	1703	2	shock
shuck	14	43	1453	2	shuck
sick	10	64	3557	2	s_ick
skank	8	44	1558	2	skank
slacks	12	44	1653	2	slacks
slank	9	58	2277	2	slank
slick	11	55	2052	2	slick
smacked	16	37	1099	2	smacked
smacker	15	34	1058	2	smacker
small	7	40	1626	2	small
smalt	7	47	2933	2	smalt
smarm	9	55	1760	2	smarm
smart	7	58	3409	2	smart
smash	10	48	1443	2	smash
smaze	16	50	1293	2	smaze
smeek	11	49	1235	2	smeek
smerk	11	54	1272	2	smerk
smirk	11	66	1275	2	smirk
smocks	14	57	1001	2	smocks
snacks	12	45	1455	2	snacks
snark	9	54	1994	2	snark
sneck	11	47	1366	2	sneck
snick	11	44	1601	2	snick
snuck	11	44	1191	2	snuck
soak	8	72	2766	2	soa_k
sock	10	52	3321	2	s_ock
space	9	53	2567	2	space
spacy	12	54	1562	2	spacy
spank	11	59	1957	2	spank
spark	11	49	2089	2	spark
speck	13	51	1565	2	speck
spick	13	45	1907	2	spick
stacks	12	43	1726	2	stacks
stalk	9	45	1800	2	stalk
stank	9	58	2330	2	stank
stark	9	54	2562	2	stark
stick	11	51	2156	2	stick
stock	11	44	1756	2	stock
stuck	11	45	1577	2	stuck
suck	10	61	3173	2	s_uck
sumac	9	95	1488	2	sumac_
sumach	13	53	1011	2	sumach
sumacs	10	55	1210	2	sumacs
swank	12	53	1823	2	swank
tack	10	65	3629	2	_tack
thack	14	49	1517	2	thack
track	11	48	2301	2	track
umiack	14	3	517	2	umiack
wack	13	53	3091	2	_wack
whack	17	48	1302	2	whack
wrack	14	54	1388	2	wrack
yack	13	54	2597	2	_yack

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.293	609866.9
2	DLD Change Limit	53800	99	1.456	36950.5
3	Display Results	99	99	0.030	3300.0
	(SQL Overall)	178691	99	1.779	100444.6