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

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

79 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
tackle	12	38	1573	(None)
cackle	14	34	1692	1	cackle
hackle	15	49	1681	1	hackle
mackle	14	37	1643	1	mackle
rackle	12	39	1729	1	rackle
tackled	14	39	1318	1	tackled
tackler	13	40	1332	1	tackler
tackles	13	38	1652	1	tackles
tickle	12	46	1674	1	tickle
ackee	11	58	2536	2	_ackee
ankle	9	52	2025	2	_ankle
buckle	14	48	1519	2	buckle
cackled	16	46	1329	2	cackled
cackler	15	38	1257	2	cackler
cackles	15	37	1720	2	cackles
cockle	14	39	1357	2	cockle
crackle	15	36	1125	2	crackle
darkle	11	38	1394	2	darkle
deckle	13	120	1245	2	deckle
facile	11	25	1488	2	facile
fickle	15	39	1297	2	fickle
grackle	14	33	889	2	grackle
hackee	15	49	2183	2	hackee
hackie	15	46	1562	2	hackie
hackled	17	33	1248	2	hackled
hackler	16	35	1235	2	hackler
hackles	16	29	1706	2	hackles
hackly	18	29	873	2	hackly
heckle	15	31	1209	2	heckle
huckle	15	39	1307	2	huckle
jackleg	21	3	503	2	jackleg
keckle	11	35	942	2	keckle
mackled	16	41	1191	2	mackled
mackles	15	44	1575	2	mackles
macle	9	61	2700	2	mac_le
macule	10	41	1527	2	macule
mickle	14	37	1513	2	mickle
muckle	14	34	1358	2	muckle
nickle	12	38	1448	2	nickle
packly	17	22	833	2	packly
pickle	14	42	1565	2	pickle
rankle	10	34	1488	2	rankle
retackle	14	4	504	2	retackle
ruckle	12	44	1458	2	ruckle
shackle	16	40	954	2	shackle
sickle	12	44	1832	2	sickle
spackle	15	36	957	2	spackle
stickle	13	24	1097	2	stickle
suckle	12	40	1596	2	suckle
table	7	54	2960	2	ta_ble
tace	6	53	4251	2	tac__e
tache	10	62	2237	2	tac_he
tack	10	65	3629	2	tack__
tacked	13	47	2394	2	tacked
tacker	12	42	2450	2	tacker
tacket	12	46	2749	2	tacket
tackey	15	46	1308	2	tackey
tackier	13	37	1252	2	tackier
tackily	16	3	750	2	tackily
tacklers	14	30	1077	2	tacklers
tackless	14	41	948	2	tackless
tacks	11	54	3013	2	tack_s
tacky	14	56	1744	2	tack_y
tactile	9	3	1061	2	tactile
taille	6	31	1692	2	taille
take	8	47	3926	2	ta_k_e
tale	4	61	5416	2	ta__le
talkie	10	39	1444	2	talkie
tamale	8	37	1740	2	tamale
tangle	7	40	1995	2	tangle
tattle	6	41	1565	2	tattle
tickled	14	43	1313	2	tickled
tickler	13	36	1265	2	tickler
tickles	13	34	1685	2	tickles
tinkle	10	37	1445	2	tinkle
trachle	12	3	1185	2	trachle
trickle	13	36	1344	2	trickle
truckle	13	35	886	2	truckle
wacke	14	59	1862	2	wack_e

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	82551	0.530	337152.8
2	DLD Change Limit	82551	79	5.670	14559.3
3	Display Results	79	79	0.016	4937.5
	(SQL Overall)	178691	79	6.216	28746.9