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

Here are the results of your fuzzy-string dictionary search for “knackery” with Change Limit: [1] [2] [3] [4]

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.

85 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
knackery	16	28	366	(None)
knacker	12	30	791	1	knacker_
knackers	13	28	684	1	knackers
flackery	20	29	524	2	flackery
knacked	13	28	779	2	knacke_d
knackered	15	4	368	2	knackered
knavery	17	3	312	2	kna_very
knickers	13	30	672	2	knickers
knocker	12	29	639	2	knocker_
knockers	13	28	573	2	knockers
quackery	26	3	311	2	quackery
snacker	13	31	1260	2	snacker_
snackers	14	30	1022	2	snackers
snickery	17	29	554	2	snickery
backer	14	45	2553	3	_backer_
backers	15	38	2189	3	_backers
bakery	15	59	1100	3	_ba_kery
blacker	15	45	1351	3	blacker_
clacker	15	38	1377	3	clacker_
clackers	16	39	1170	3	clackers
cracker	15	31	1417	3	cracker_
crackers	16	41	1172	3	crackers
crockery	19	35	660	3	crockery
dacker	13	49	2075	3	_dacker_
dackers	14	34	1704	3	_dackers
enactory	13	4	615	3	enactory
fakery	16	50	926	3	_fa_kery
flickery	20	36	510	3	flickery
hacker	15	48	2269	3	_hacker_
hackers	16	46	1904	3	_hackers
jacker	19	44	1758	3	_jacker_
jackers	20	42	1445	3	_jackers
kicker	11	41	1618	3	k_icker_
kickers	12	40	1329	3	k_ickers
knack	10	43	1104	3	knack___
knackeries	15	4	410	3	knackeries
knacking	14	29	671	3	knacking
knacks	11	42	854	3	knack__s
knapper	15	38	715	3	knapper_
knappers	16	31	564	3	knappers
knarry	13	3	461	3	kna__rry
knocked	13	23	630	3	knocke_d
knuckler	13	8	362	3	knuckler_
knucklers	14	8	304	3	knucklers
knuckly	15	4	247	3	knuck_ly
lacker	12	53	2562	3	_lacker_
lackers	13	41	2054	3	_lackers
lackey	15	48	1335	3	_lacke_y
mockery	18	37	691	3	_mockery
napery	11	48	981	3	_na_pery
necker	12	40	1279	3	_necker_
neckers	13	42	1046	3	_neckers
nicker	12	38	1870	3	_nicker_
nickers	13	44	1509	3	_nickers
packer	14	42	2340	3	_packer_
packers	15	38	1889	3	_packers
puckery	18	30	626	3	_puckery
racker	12	48	2455	3	_racker_
rackers	13	43	2045	3	_rackers
rackety	16	49	911	3	_rackety
rockery	16	43	925	3	_rockery
sacker	12	51	2484	3	_sacker_
sackers	13	38	2022	3	_sackers
slacker	13	39	1529	3	slacker_
slackers	14	38	1274	3	slackers
smacker	15	34	1058	3	smacker_
smackers	16	31	871	3	smackers
snacked	14	40	1311	3	snacke_d
snakey	13	50	1127	3	sna_ke_y
snicker	13	30	1267	3	snicker_
snickers	14	30	1096	3	snickers
stacker	13	44	1626	3	stacker_
stackers	14	34	1356	3	stackers
tacker	12	42	2450	3	_tacker_
tackers	13	43	1962	3	_tackers
tackey	15	46	1308	3	_tacke_y
tracery	12	39	979	3	trac_ery
tracker	13	35	1517	3	tracker_
trackers	14	35	1285	3	trackers
trickery	17	29	734	3	trickery
unpacker	16	21	589	3	unpacker_
unpackers	17	20	381	3	unpackers
wacker	15	49	2012	3	_wacker_
whacker	19	36	850	3	whacker_
whackers	20	32	654	3	whackers

Search took 7 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	146162	0.436	409841.7
2	DLD Change Limit	146162	85	6.420	22766.7
3	Display Results	85	85	0.033	2575.8
	(SQL Overall)	178691	85	6.889	25938.6