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

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

59 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
knack	10	43	1104	(None)
knacks	11	42	854	1	knacks
knock	10	48	796	1	knock
kyack	13	46	826	1	kyack
snack	11	47	1806	1	snack
aback	13	48	1617	2	aback
alack	11	48	2006	2	alack
back	12	55	3576	2	_back
black	13	47	1907	2	black
clack	13	47	2017	2	clack
crack	13	41	2053	2	crack
enact	7	35	2536	2	enact
flack	14	45	1941	2	flack
hack	13	51	3454	2	_hack
jack	17	52	2486	2	_jack
keck	9	49	2071	2	k_eck
kick	9	60	2607	2	k_ick
klick	10	53	1143	2	klick
knacked	13	28	779	2	knacked
knacker	12	30	791	2	knacker
knap	10	58	1540	2	kna_p
knaps	11	55	1117	2	knaps
knar	8	58	1872	2	kna_r
knars	9	44	1611	2	knars
knaur	9	50	825	2	knaur
knave	12	38	946	2	knave
knawe	12	39	788	2	knawe
knocks	11	39	744	2	knocks
kyacks	14	41	606	2	kyacks
kyak	10	52	1363	2	kya_k
lack	10	58	3768	2	_lack
mack	12	57	3365	2	_mack
nark	8	52	3006	2	_nark
neck	10	54	2366	2	_neck
nick	10	66	2760	2	_nick
nock	10	61	2718	2	_nock
pack	12	55	3544	2	_pack
plack	13	50	1784	2	plack
quack	20	38	1250	2	quack
rack	10	62	3488	2	_rack
sack	10	53	3731	2	_sack
shack	14	53	2175	2	shack
slack	11	50	2176	2	slack
smack	13	46	1545	2	smack
snacks	12	45	1455	2	snacks
snark	9	54	1994	2	snark
sneck	11	47	1366	2	sneck
snick	11	44	1601	2	snick
snuck	11	44	1191	2	snuck
stack	11	44	2169	2	stack
tack	10	65	3629	2	_tack
thack	14	49	1517	2	thack
track	11	48	2301	2	track
unpack	14	5	783	2	unpack
untack	12	3	976	2	untack
wack	13	53	3091	2	_wack
whack	17	48	1302	2	whack
wrack	14	54	1388	2	wrack
yack	13	54	2597	2	_yack

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	53800	0.310	576422.6
2	DLD Change Limit	53800	59	1.736	30990.8
3	Display Results	59	59	0.013	4538.5
	(SQL Overall)	178691	59	2.059	86785.3