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

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

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
tackles	13	38	1652	(None)
cackles	15	37	1720	1	cackles
hackles	16	29	1706	1	hackles
mackles	15	44	1575	1	mackles
tackle	12	38	1573	1	tackle_
tackled	14	39	1319	1	tackled
tackler	13	40	1332	1	tackler
tacklers	14	30	1077	1	tacklers
tackless	14	41	948	1	tackless
tickles	13	34	1685	1	tickles
ackees	12	49	1458	2	_ackees
ankles	10	48	1838	2	_ankles
backless	16	29	1063	2	backless
buckles	15	34	1609	2	buckles
cackle	14	34	1692	2	cackle_
cackled	16	46	1330	2	cackled
cackler	15	38	1257	2	cackler
cacklers	16	37	1070	2	cacklers
cockles	15	34	1464	2	cockles
crackles	16	41	1127	2	crackles
darkles	12	40	1193	2	darkles
deckles	14	33	1280	2	deckles
grackles	15	30	918	2	grackles
hackees	16	50	1410	2	hackees
hackies	16	34	1824	2	hackies
hackle	15	49	1681	2	hackle_
hackled	17	33	1249	2	hackled
hackler	16	35	1235	2	hackler
hacklers	17	37	1030	2	hacklers
heckles	16	37	1138	2	heckles
huckles	16	36	1262	2	huckles
jacales	16	3	1032	2	jacales
jackies	20	29	1262	2	jackies
jackleg	21	3	504	2	jackleg
jacklegs	22	3	396	2	jacklegs
keckles	12	31	876	2	keckles
mackle	14	37	1643	2	mackle_
mackled	16	41	1192	2	mackled
macles	10	70	2322	2	mac_les
macules	11	40	1513	2	macules
mickles	15	34	1500	2	mickles
muckles	15	34	1325	2	muckles
nickles	13	37	1382	2	nickles
pickles	15	32	1544	2	pickles
rackle	12	39	1729	2	rackle_
rankles	11	31	1454	2	rankles
retackles	15	4	536	2	retackles
ruckles	13	34	1460	2	ruckles
shackles	17	30	1059	2	shackles
sickles	13	34	1754	2	sickles
spackles	16	31	995	2	spackles
stackless	15	5	593	2	stackless
stickles	14	25	1210	2	stickles
suckles	13	45	1674	2	suckles
tables	8	45	2489	2	ta_bles
taces	7	62	3780	2	tac__es
taches	11	42	2417	2	tac_hes
tacked	13	47	2394	2	tack_ed
tacker	12	42	2450	2	tack_er
tackers	13	43	1962	2	tackers
tacket	12	46	2749	2	tack_et
tackets	13	49	1436	2	tackets
tackey	15	46	1308	2	tack_ey
tackier	13	37	1252	2	tackier
tackiest	14	31	1243	2	tackiest
tacks	11	54	3013	2	tack__s
tactless	10	28	846	2	tactless
tailles	7	25	1647	2	tailles
takes	9	44	3779	2	ta_k_es
tales	5	54	5137	2	ta__les
talkies	11	34	1573	2	talkies
tamales	9	32	1615	2	tamales
tangles	8	39	2004	2	tangles
tankless	12	26	782	2	tankless
tattles	7	36	1628	2	tattles
tickle	12	46	1674	2	tickle_
tickled	14	43	1313	2	tickled
tickler	13	36	1265	2	tickler
ticklers	14	33	930	2	ticklers
tinkles	11	37	1392	2	tinkles
trachles	13	3	1175	2	trachles
trackless	15	24	672	2	trackless
trickles	14	30	1376	2	trickles
truckles	14	31	938	2	truckles
wackes	15	47	1771	2	wack_es

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.373	479064.3
2	DLD Change Limit	107671	85	3.483	30913.3
3	Display Results	85	85	0.033	2575.8
	(SQL Overall)	178691	85	3.889	45947.8