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

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

70 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
cackled	16	46	1330	(None)
cackle	14	34	1692	1	cackle_
cackler	15	38	1257	1	cackler
cackles	15	37	1720	1	cackles
cockled	16	37	1082	1	cockled
crackled	17	42	886	1	crackled
hackled	17	33	1249	1	hackled
mackled	16	41	1192	1	mackled
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
cabled	11	48	1987	2	ca_bled
cached	14	54	1920	2	cac_hed
cacklers	16	37	1070	2	cacklers
cajoled	17	42	828	2	cajoled
caked	12	61	2862	2	ca_k_ed
calked	13	46	1740	2	calk_ed
called	9	41	2673	2	ca_lled
canaled	10	36	1556	2	canaled
canceled	13	27	940	2	canceled
candled	11	38	1574	2	candled
carked	13	40	2482	2	cark_ed
caroled	10	37	1769	2	caroled
casked	13	48	1551	2	cask_ed
castled	10	43	1151	2	castled
caulked	14	48	667	2	caulked
caviled	13	4	872	2	caviled
chuckled	20	4	516	2	chuckled
clacked	16	41	1360	2	clack_ed
cocked	15	50	2256	2	cock_ed
cockle	14	39	1357	2	cockle_
cockles	15	34	1464	2	cockles
cracked	16	35	1474	2	crack_ed
crackle	15	36	1125	2	crackle_
crackles	16	41	1127	2	crackles
crankled	15	40	815	2	crankled
cycled	14	3	654	2	cyc_led
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
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
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 5 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	70	3.593	29966.9
3	Display Results	70	70	0.030	2333.3
	(SQL Overall)	178691	70	3.999	44683.9