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

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

62 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
whacker	19	36	850	(None)
hacker	15	48	2269	1	_hacker
wacker	15	49	2012	1	w_acker
whacked	20	45	862	1	whacked
whackers	20	32	654	1	whackers
whackier	20	4	467	1	whackier
whicker	19	35	977	1	whicker
backer	14	45	2552	2	_backer
blacker	15	45	1351	2	blacker
checker	18	32	953	2	checker
clacker	15	38	1377	2	clacker
cracker	15	31	1417	2	cracker
dacker	13	49	2075	2	_dacker
hacked	16	49	2351	2	_hacked
hackee	15	49	2183	2	_hackee
hackers	16	46	1904	2	_hackers
hackler	16	35	1235	2	_hackler
hanker	13	46	2209	2	_hanker
hawker	16	48	1266	2	_hawker
hocker	15	51	1856	2	_hocker
jacker	19	44	1758	2	_jacker
knacker	12	30	791	2	knacker
lacker	12	53	2562	2	_lacker
packer	14	42	2340	2	_packer
racker	12	48	2455	2	_racker
sacker	12	51	2484	2	_sacker
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	1143	2	shocker
shucker	16	37	1010	2	shucker
slacker	13	39	1529	2	slacker
smacker	15	34	1058	2	smacker
snacker	13	31	1260	2	snacker
stacker	13	44	1626	2	stacker
tacker	12	42	2450	2	_tacker
thacked	17	38	1020	2	thacked
thanker	14	30	959	2	thanker
thicker	16	36	1102	2	thicker
thwacker	20	4	287	2	thwacker
tracker	13	35	1517	2	tracker
wacke	14	59	1862	2	w_acke_
wackes	15	47	1771	2	w_ackes
wackier	16	36	973	2	w_ackier
waker	12	55	2659	2	w_a_ker
walker	13	39	1399	2	w_alker
wanker	13	42	1997	2	w_anker
weaker	13	40	1544	2	wea_ker
whack	17	48	1302	2	whack__
whacko	18	47	703	2	whack_o
whackos	19	37	526	2	whackos
whacks	18	46	1048	2	whack_s
whacky	21	55	649	2	whack_y
whaler	12	46	1197	2	wha_ler
whapper	17	34	827	2	whapper
whickers	20	29	798	2	whickers
whisker	17	36	793	2	whisker
wicker	15	45	1867	2	w_icker
wracked	17	41	1011	2	wracked
wrecker	16	36	760	2	wrecker

Search took 4 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.373	479064.3
2	DLD Change Limit	107671	62	2.796	38508.9
3	Display Results	62	62	0.016	3875.0
	(SQL Overall)	178691	62	3.185	56103.9