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

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

51 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
cachets	14	50	1426	(None)
caches	13	79	2691	1	cache_s
cachet	13	45	2641	1	cachet_
rachets	12	45	1683	1	rachets
sachets	12	39	1410	1	sachets
aches	10	61	3229	2	_ache_s
baches	13	54	2694	2	bache_s
brachets	15	43	1198	2	brachets
cablets	11	42	1634	2	cablets
cache	12	51	2248	2	cache__
cached	14	54	1920	2	cache_d
cachepots	18	5	322	2	cachepots
cacheted	16	14	823	2	cacheted
cachexy	24	4	328	2	cachexy
cachous	14	3	1258	2	cachous
cadets	9	63	1651	2	ca_dets
callets	9	38	2170	2	callets
camlets	11	43	1462	2	camlets
caplets	11	49	1452	2	caplets
carets	8	53	3077	2	ca_rets
carnets	9	39	1840	2	carnets
carpets	11	39	1533	2	carpets
cashes	11	47	2988	2	cashe_s
cashews	15	42	860	2	cashews
caskets	13	39	1017	2	caskets
catchers	15	31	1406	2	catchers
catches	14	43	2077	2	catche_s
cathects	15	4	579	2	cathects
coachers	15	43	1230	2	coachers
coaches	14	40	1869	2	coache_s
crochets	15	35	983	2	crochets
facets	11	63	1665	2	fac_ets
hatchets	16	33	1038	2	hatchets
jackets	20	50	1137	2	jackets
laches	11	65	2834	2	lache_s
latchets	13	34	1001	2	latchets
maches	13	48	2723	2	mache_s
machete	14	3	1088	2	machete
machetes	15	3	963	2	machetes
manchets	15	26	957	2	manchets
naches	11	46	2241	2	nache_s
packets	15	51	1477	2	packets
rachet	11	50	2897	2	rachet_
rackets	13	49	1687	2	rackets
ratchets	13	31	1026	2	ratchets
rochets	12	42	1347	2	rochets
sachems	14	34	890	2	sachems
sachet	11	47	2577	2	sachet_
taches	11	42	2417	2	tache_s
tackets	13	49	1436	2	tackets
yachts	14	3	702	2	yach_ts

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	51	3.313	32499.5
3	Display Results	51	51	0.016	3187.5
	(SQL Overall)	178691	51	3.702	48268.8