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

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

72 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
tackled	14	39	1319	(None)
cackled	16	46	1330	1	cackled
hackled	17	33	1249	1	hackled
mackled	16	41	1192	1	mackled
tacked	13	47	2394	1	tack_ed
tackle	12	38	1573	1	tackle_
tackler	13	40	1332	1	tackler
tackles	13	38	1652	1	tackles
tickled	14	43	1313	1	tickled
ankled	11	43	1348	2	_ankled
backed	15	57	2572	2	back_ed
buckled	16	44	1188	2	buckled
cackle	14	34	1692	2	cackle_
cackler	15	38	1257	2	cackler
cackles	15	37	1720	2	cackles
cockled	16	37	1082	2	cockled
crackled	17	42	886	2	crackled
darkled	13	37	872	2	darkled
hacked	16	49	2351	2	hack_ed
hackle	15	49	1681	2	hackle_
hackler	16	35	1235	2	hackler
hackles	16	29	1706	2	hackles
heckled	17	31	846	2	heckled
jacked	20	48	1752	2	jack_ed
jackleg	21	3	504	2	jackleg
keckled	13	37	650	2	keckled
lacked	13	53	2465	2	lack_ed
mackle	14	37	1643	2	mackle_
mackles	15	44	1575	2	mackles
macled	11	67	1811	2	mac_led
maculed	12	35	1005	2	maculed
nickled	14	40	1044	2	nickled
packed	15	48	2260	2	pack_ed
pickled	16	40	1188	2	pickled
racked	13	45	2608	2	rack_ed
rackle	12	39	1729	2	rackle_
rankled	12	39	1065	2	rankled
retackled	16	4	407	2	retackled
ruckled	14	41	1103	2	ruckled
sacked	13	55	2521	2	sack_ed
shackled	18	27	760	2	shackled
sickled	14	47	1343	2	sickled
spackled	17	29	780	2	spackled
stacked	14	34	1612	2	stack_ed
stickled	15	29	897	2	stickled
suckled	14	42	1251	2	suckled
tabled	9	40	2004	2	ta_bled
tacker	12	42	2450	2	tack_er
tacket	12	46	2749	2	tack_et
tackey	15	46	1308	2	tack_ey
tackier	13	37	1252	2	tackier
tacklers	14	30	1077	2	tacklers
tackless	14	41	948	2	tackless
tailed	7	44	2466	2	ta_iled
talcked	14	4	634	2	talck_ed
talked	11	40	1540	2	talk_ed
tangled	9	42	1463	2	tangled
tanked	11	39	1929	2	tank_ed
tasked	11	47	1464	2	task_ed
tattled	8	43	1148	2	tattled
thacked	17	38	1020	2	thack_ed
ticked	13	47	2052	2	tick_ed
tickle	12	46	1674	2	tickle_
tickler	13	36	1265	2	tickler
tickles	13	34	1685	2	tickles
tinkled	12	39	1047	2	tinkled
trachled	14	3	831	2	trachled
tracked	14	37	1613	2	track_ed
trickled	15	26	1043	2	trickled
truckled	15	32	731	2	truckled
tucked	13	40	1749	2	tuck_ed
yacked	16	45	1679	2	yack_ed

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.406	440125.6
2	DLD Change Limit	107671	72	3.143	34257.4
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	3.579	49927.6