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

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

89 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
smacks	14	41	1232	(None)
macks	13	51	2760	1	_macks
sacks	11	42	2887	1	s_acks
shacks	15	48	1756	1	shacks
slacks	12	44	1653	1	slacks
smack	13	46	1545	1	smack_
smocks	14	57	1001	1	smocks
snacks	12	45	1455	1	snacks
stacks	12	43	1726	1	stacks
amucks	14	6	600	2	amucks
backs	13	57	2962	2	_backs
blacks	14	49	1495	2	blacks
clacks	14	45	1634	2	clacks
cracks	14	48	1700	2	cracks
flacks	15	41	1453	2	flacks
hacks	14	49	2871	2	_hacks
jacks	18	52	1983	2	_jacks
knacks	11	42	854	2	knacks
kyacks	14	41	606	2	kyacks
lacks	11	61	2920	2	_lacks
maces	9	71	3996	2	_maces
machs	12	57	2256	2	_machs
mack	12	57	3364	2	_mack_
macs	8	67	4250	2	_mac_s
marks	11	59	3348	2	_marks
masks	11	53	2053	2	_masks
micks	13	55	2537	2	_micks
mocks	13	50	2382	2	_mocks
mucks	13	46	2264	2	_mucks
packs	13	55	2893	2	_packs
placks	14	44	1415	2	placks
quacks	21	47	1010	2	quacks
racks	11	50	2885	2	_racks
sack	10	53	3731	2	s_ack_
sacs	6	57	3907	2	s_ac_s
sameks	12	40	932	2	sameks
sarks	9	66	3246	2	s_arks
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
shmucks	18	3	394	2	shmucks
shocks	15	44	1457	2	shocks
shucks	15	40	1041	2	shucks
sicks	11	51	2762	2	s_icks
skanks	9	47	1083	2	skanks
slack	11	50	2176	2	slack_
slicks	12	48	1611	2	slicks
smacked	16	37	1099	2	smacked
smacker	15	34	1058	2	smacker
smackers	16	31	871	2	smackers
smalls	8	45	1412	2	smalls
smalts	8	52	1489	2	smalts
smarms	10	57	1253	2	smarms
smarts	8	62	1800	2	smarts
smazes	17	43	1166	2	smazes
smeeks	12	42	843	2	smeeks
smerks	12	44	971	2	smerks
smirks	12	49	1012	2	smirks
smock	13	53	1167	2	smock_
snack	11	47	1806	2	snack_
snarks	10	48	1573	2	snarks
snecks	12	44	1003	2	snecks
snicks	12	43	1247	2	snicks
soaks	9	52	2029	2	soa_ks
socks	11	49	2608	2	s_ocks
spaces	10	47	2263	2	spaces
spanks	12	45	1412	2	spanks
sparks	12	46	1636	2	sparks
specks	14	43	1270	2	specks
spicks	14	48	1499	2	spicks
stack	11	44	2169	2	stack_
stalks	10	46	1455	2	stalks
stanks	10	49	1770	2	stanks
sticks	12	51	1861	2	sticks
stocks	12	47	1563	2	stocks
sucks	11	45	2307	2	s_ucks
sumachs	14	45	735	2	sumachs
sumacs	10	55	1210	2	sumac_s
swanks	13	48	1156	2	swanks
tacks	11	54	3013	2	_tacks
thacks	15	43	1192	2	thacks
tracks	12	48	1884	2	tracks
umiacks	15	3	401	2	umiacks
wacks	14	66	2628	2	_wacks
whacks	18	46	1048	2	whacks
wracks	15	47	1111	2	wracks
yacks	14	44	1981	2	_yacks

Search took 5 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.123	1452772.4
2	DLD Change Limit	82551	89	4.330	19064.9
3	Display Results	89	89	0.046	1934.8
	(SQL Overall)	178691	89	4.499	39717.9