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

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

54 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
knacked	13	28	779	(None)
knacker	12	30	791	1	knacker
knocked	13	23	630	1	knocked
snacked	14	40	1311	1	snacked
backed	15	57	2572	2	_backed
blacked	16	36	1337	2	blacked
clacked	16	41	1360	2	clacked
cracked	16	35	1474	2	cracked
enacted	10	3	1064	2	enacted
flacked	17	37	1158	2	flacked
hacked	16	49	2351	2	_hacked
jacked	20	48	1752	2	_jacked
kecked	12	51	1317	2	k_ecked
kicked	12	44	1594	2	k_icked
knack	10	43	1104	2	knack__
knackered	15	4	368	2	knackered
knackers	13	28	684	2	knackers
knackery	16	28	366	2	knackery
knacks	11	42	854	2	knack_s
knapped	16	39	710	2	knapped
knarred	12	26	600	2	knarred
knocker	12	29	639	2	knocker
knuckled	14	6	356	2	knuckled
lacked	13	53	2465	2	_lacked
nacred	9	52	1250	2	_nacred
naked	10	53	2085	2	_na_ked
narked	11	41	1674	2	_narked
necked	13	47	1507	2	_necked
nicked	13	50	1968	2	_nicked
nocked	13	46	1738	2	_nocked
packed	15	48	2260	2	_packed
quacked	23	3	679	2	quacked
racked	13	45	2608	2	_racked
sacked	13	55	2521	2	_sacked
shacked	17	40	1539	2	shacked
slacked	14	38	1545	2	slacked
smacked	16	37	1099	2	smacked
snacker	13	31	1260	2	snacker
snaked	11	50	1759	2	sna_ked
snicked	14	38	1163	2	snicked
stacked	14	34	1612	2	stacked
swacked	17	31	1052	2	swacked
tacked	13	47	2394	2	_tacked
thacked	17	38	1020	2	thacked
tracked	14	37	1613	2	tracked
unacted	10	3	1273	2	unacted
unasked	12	20	1002	2	unasked
unbacked	17	26	873	2	unbacked
uncaked	14	35	1435	2	uncaked
unpacked	17	26	866	2	unpacked
untacked	15	23	992	2	untacked
whacked	20	45	862	2	whacked
wracked	17	41	1011	2	wracked
yacked	16	45	1679	2	_yacked

Search took 6 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.940	190096.8
2	DLD Change Limit	107671	54	4.950	21751.7
3	Display Results	54	54	0.016	3375.0
	(SQL Overall)	178691	54	5.906	30255.8