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

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

86 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
whacks	18	46	1048	(None)
hacks	14	49	2871	1	_hacks
shacks	15	48	1756	1	shacks
thacks	15	43	1192	1	thacks
wacks	14	66	2628	1	w_acks
whack	17	48	1302	1	whack_
whacko	18	47	703	1	whacko
whackos	19	37	526	1	whackos
whacky	21	55	649	1	whacky
wracks	15	47	1111	1	wracks
backs	13	57	2962	2	_backs
blacks	14	49	1495	2	blacks
chalks	15	54	1214	2	chalks
charks	15	52	1970	2	charks
checks	17	49	1270	2	checks
chicks	17	53	1759	2	chicks
chocks	17	48	1531	2	chocks
chucks	17	48	1293	2	chucks
clacks	14	45	1634	2	clacks
cracks	14	48	1700	2	cracks
dhaks	13	47	970	2	dha_ks
flacks	15	41	1453	2	flacks
haceks	15	44	786	2	_haceks
hack	13	51	3454	2	_hack_
haiks	12	51	2093	2	_haiks
hanks	12	62	2686	2	_hanks
harks	12	63	3343	2	_harks
hawks	15	54	1570	2	_hawks
hecks	14	52	2065	2	_hecks
hicks	14	53	2217	2	_hicks
hocks	14	49	2549	2	_hocks
hucks	14	43	2217	2	_hucks
jacks	18	52	1983	2	_jacks
knacks	11	42	854	2	knacks
kyacks	14	41	606	2	kyacks
lacks	11	61	2920	2	_lacks
macks	13	51	2760	2	_macks
packs	13	55	2893	2	_packs
placks	14	44	1415	2	placks
quacks	21	47	1010	2	quacks
racks	11	50	2885	2	_racks
sacks	11	42	2887	2	_sacks
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
shocks	15	44	1458	2	shocks
shucks	15	40	1041	2	shucks
slacks	12	44	1653	2	slacks
smacks	14	41	1232	2	smacks
snacks	12	45	1455	2	snacks
stacks	12	43	1726	2	stacks
tacks	11	54	3013	2	_tacks
thack	14	49	1517	2	thack_
thanks	13	43	1313	2	thanks
thicks	15	45	1199	2	thicks
thwacks	19	5	361	2	thwacks
tracks	12	48	1884	2	tracks
wack	13	53	3091	2	w_ack_
wacke	14	59	1862	2	w_acke
wackes	15	47	1771	2	w_ackes
wacko	14	55	1438	2	w_acko
wackos	15	52	1099	2	w_ackos
wacky	17	47	1493	2	w_acky
walks	12	62	1850	2	w_alks
wanks	12	61	2448	2	w_anks
warks	12	79	3240	2	w_arks
wauks	12	55	1516	2	w_auks
whacked	20	45	862	2	whacked
whacker	19	36	850	2	whacker
whackers	20	32	654	2	whackers
whales	12	47	1694	2	whales
whams	13	55	1564	2	wha_ms
whangs	13	43	972	2	whangs
whaps	13	51	1516	2	wha_ps
wharfs	15	4	637	2	wharfs
whats	11	77	1899	2	wha_ts
whaups	14	40	575	2	whaups
whelks	16	36	732	2	whelks
whisks	16	49	735	2	whisks
wicks	14	46	1936	2	w_icks
wrack	14	54	1388	2	wrack_
wrecks	15	41	888	2	wrecks
wricks	15	46	1062	2	wricks
yacks	14	44	1981	2	_yacks

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	86	2.406	34310.5
3	Display Results	86	86	0.030	2866.7
	(SQL Overall)	178691	86	2.779	64300.5