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

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

66 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
mackled	16	41	1192	(None)
cackled	16	46	1330	1	cackled
hackled	17	33	1249	1	hackled
mackle	14	37	1643	1	mackle_
mackles	15	44	1575	1	mackles
macled	11	67	1811	1	mac_led
maculed	12	35	1005	1	maculed
tackled	14	39	1319	1	tackled
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
maced	10	85	2869	2	mac__ed
macle	9	61	2700	2	mac_le_
macles	10	70	2322	2	mac_les
macule	10	41	1527	2	macule_
macules	11	40	1513	2	macules
mailed	9	53	2675	2	ma_iled
malled	9	46	2611	2	ma_lled
mangled	11	36	1526	2	mangled
mantled	10	41	1339	2	mantled
marbled	12	32	1211	2	marbled
marked	13	39	2162	2	mark_ed
marled	9	55	2316	2	ma_rled
masked	13	43	1652	2	mask_ed
mauled	9	48	1782	2	ma_uled
mickle	14	37	1513	2	mickle_
mickler	15	33	1023	2	mickler
mickles	15	34	1500	2	mickles
mocked	15	47	1661	2	mock_ed
mucked	15	38	1609	2	muck_ed
muckle	14	34	1358	2	muckle_
muckles	15	34	1325	2	muckles
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
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
smacked	16	37	1099	2	smack_ed
spackled	17	29	780	2	spackled
suckled	14	42	1251	2	suckled
tacked	13	47	2394	2	tack_ed
tackle	12	38	1573	2	tackle_
tackler	13	40	1332	2	tackler
tackles	13	38	1652	2	tackles
tickled	14	43	1313	2	tickled
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.373	479064.3
2	DLD Change Limit	107671	66	3.233	33303.7
3	Display Results	66	66	0.033	2000.0
	(SQL Overall)	178691	66	3.639	49104.4