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

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

57 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
whacking	21	37	748	(None)
hacking	17	37	2061	1	_hacking
shacking	18	40	1408	1	shacking
thacking	18	31	1004	1	thacking
wracking	18	34	996	1	wracking
backing	16	55	2344	2	_backing
blacking	17	42	1360	2	blacking
chalking	18	33	1006	2	chalking
charking	18	35	1261	2	charking
checking	20	37	920	2	checking
chocking	20	40	1101	2	chocking
chucking	20	37	950	2	chucking
clacking	17	33	1349	2	clacking
cracking	17	40	1390	2	cracking
flacking	18	43	1179	2	flacking
hackling	18	33	1016	2	_hackling
hanking	15	46	1910	2	_hanking
harking	15	41	2094	2	_harking
hawking	18	37	1142	2	_hawking
hocking	17	34	1724	2	_hocking
jacking	21	45	1526	2	_jacking
knacking	14	29	671	2	knacking
lacking	14	38	2154	2	_lacking
packing	16	44	2072	2	_packing
quacking	24	3	674	2	quacking
racking	14	43	2366	2	_racking
sacking	14	41	2270	2	_sacking
shackling	19	28	617	2	shackling
shaking	15	33	1725	2	sha_king
shanking	16	36	1228	2	shanking
sharking	16	39	1297	2	sharking
shocking	18	43	1154	2	shocking
shucking	18	33	943	2	shucking
slacking	15	39	1413	2	slacking
smacking	17	35	1076	2	smacking
snacking	15	34	1170	2	snacking
stacking	15	42	1508	2	stacking
tacking	14	44	2148	2	_tacking
thanking	16	40	952	2	thanking
thwacking	22	5	319	2	thwacking
tracking	15	37	1546	2	tracking
waking	14	48	2138	2	w_a_king
walking	15	40	1330	2	w_alking
wanking	15	42	1678	2	w_anking
warking	15	35	1957	2	w_arking
wauking	15	34	1001	2	w_auking
whackier	20	4	467	2	whackier
whaling	14	39	1077	2	wha_ling
whamming	19	27	522	2	whamming
whanging	16	26	714	2	whanging
whapping	19	31	711	2	whapping
wharfing	18	3	468	2	wharfing
whisking	19	28	661	2	whisking
wicking	17	34	1477	2	w_icking
wrecking	18	32	815	2	wrecking
wricking	18	34	949	2	wricking
yacking	17	43	1568	2	_yacking

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	121059	0.390	458182.1
2	DLD Change Limit	121059	57	3.640	33258.0
3	Display Results	57	57	0.016	3562.5
	(SQL Overall)	178691	57	4.046	44164.9