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

Here are the results of your fuzzy-string dictionary search for “deckles” 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
deckles	14	33	1280	(None)
deciles	10	44	1772	1	deciles
deckels	14	36	736	1	deckels
deckle	13	120	1245	1	deckle_
heckles	16	37	1138	1	heckles
keckles	12	31	876	1	keckles
buckles	15	34	1609	2	buckles
cackles	15	37	1720	2	cackles
cockles	15	34	1464	2	cockles
darkles	12	40	1193	2	darkles
decades	11	36	1551	2	decades
decals	9	37	1771	2	decal_s
decanes	10	31	1891	2	decanes
decares	10	28	1853	2	decares
decides	11	42	1765	2	decides
decile	9	46	1921	2	decile_
decked	14	52	1762	2	deck_ed
deckel	13	49	1104	2	deck_el
decker	13	52	1599	2	deck_er
deckers	14	44	1383	2	deckers
decks	12	48	2219	2	deck__s
decodes	11	39	1498	2	decodes
decrees	10	25	1312	2	decrees
decries	10	33	1981	2	decries
decuples	13	9	528	2	decuples
defiles	11	40	1684	2	defiles
dekes	10	52	2445	2	de_k_es
deles	6	51	3925	2	de__les
dickies	14	34	1634	2	dickies
duckies	14	36	1381	2	duckies
feckless	17	22	578	2	feckless
freckles	17	12	638	2	freckles
geckoes	14	32	579	2	geckoes
hackles	16	29	1706	2	hackles
heckle	15	31	1209	2	heckle_
heckled	17	31	846	2	heckled
heckler	16	27	857	2	heckler
hecklers	17	35	712	2	hecklers
huckles	16	36	1262	2	huckles
keckle	11	35	942	2	keckle_
keckled	13	37	650	2	keckled
mackles	15	44	1575	2	mackles
mickles	15	34	1500	2	mickles
muckles	15	34	1325	2	muckles
neckless	14	23	643	2	neckless
nickles	13	37	1382	2	nickles
pickles	15	32	1544	2	pickles
reckless	14	25	797	2	reckless
ruckles	13	34	1460	2	ruckles
sickles	13	34	1754	2	sickles
speckles	16	26	813	2	speckles
suckles	13	45	1674	2	suckles
tackles	13	38	1652	2	tackles
tickles	13	34	1685	2	tickles

Search took 4 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.376	475242.0
2	DLD Change Limit	107671	54	3.123	34476.8
3	Display Results	54	54	0.016	3375.0
	(SQL Overall)	178691	54	3.515	50836.7