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

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

37 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
shackler	17	31	797	(None)
hackler	16	35	1235	1	_hackler
shackle	16	40	954	1	shackle_
shackled	18	27	760	1	shackled
shacklers	18	33	603	1	shacklers
shackles	17	30	1059	1	shackles
cackler	15	38	1257	2	_cackler
chuckler	19	3	555	2	chuckler
hacker	15	48	2269	2	_hack_er
hackle	15	49	1681	2	_hackle_
hackled	17	33	1249	2	_hackled
hacklers	17	37	1030	2	_hacklers
hackles	16	29	1706	2	_hackles
hacklier	17	3	713	2	_hacklier
heckler	16	27	857	2	_heckler
sacker	12	51	2484	2	s_ack_er
shacked	17	40	1539	2	shack_ed
shackoes	17	36	785	2	shackoes
shaker	13	43	1946	2	sha_k_er
shakier	14	34	1115	2	sha_kier
sharker	14	43	1381	2	shark_er
shicker	16	39	1482	2	shick_er
shocker	16	34	1143	2	shock_er
shucker	16	37	1010	2	shuck_er
slacker	13	39	1529	2	slack_er
smacker	15	34	1058	2	smack_er
snacker	13	31	1260	2	snack_er
spackle	15	36	957	2	spackle_
spackled	17	29	780	2	spackled
spackles	16	31	995	2	spackles
sparkler	14	31	798	2	sparkler
stacker	13	44	1626	2	stack_er
stickler	14	25	957	2	stickler
suckler	13	34	1309	2	s_uckler
tackler	13	40	1332	2	_tackler
whacker	19	36	850	2	whack_er
whackier	20	4	467	2	whackier

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	37	3.923	30858.8
3	Display Results	37	37	0.013	2846.2
	(SQL Overall)	178691	37	4.326	41306.3