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

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

58 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
cachet	13	45	2641	(None)
cache	12	51	2248	1	cache_
cached	14	54	1920	1	cached
caches	13	79	2691	1	caches
cachets	14	50	1426	1	cachets
rachet	11	50	2897	1	rachet
sachet	11	47	2577	1	sachet
ache	9	68	2982	2	_ache_
ached	11	92	2783	2	_ached
aches	10	61	3229	2	_aches
bached	14	55	1989	2	bached
baches	13	54	2694	2	baches
brachet	14	40	2031	2	brachet
cablet	10	44	2946	2	cablet
cachepot	17	4	499	2	cachepot
cacheted	16	14	823	2	cacheted
cachexy	24	4	328	2	cachexy
cachou	13	3	1061	2	cachou
cadet	8	53	3933	2	ca_det
callet	8	45	3676	2	callet
camlet	10	44	2658	2	camlet
caplet	10	42	2681	2	caplet
caret	7	53	6056	2	ca_ret
carnet	8	47	3287	2	carnet
carpet	10	45	3009	2	carpet
cashed	12	51	2435	2	cashed
cashes	11	47	2988	2	cashes
cashew	14	43	1145	2	cashew
casket	12	48	2099	2	casket
catcher	14	31	1582	2	catcher
catches	14	43	2076	2	catches
cathect	14	3	986	2	cathect
coached	15	33	1384	2	coached
coacher	14	37	1411	2	coacher
coaches	14	40	1869	2	coaches
crochet	14	36	1666	2	crochet
facet	10	60	3852	2	fac_et
hatchet	15	33	1756	2	hatchet
jacket	19	47	2067	2	jacket
laches	11	65	2834	2	laches
latchet	12	31	1790	2	latchet
mache	12	59	2530	2	mache_
maches	13	48	2723	2	maches
machete	14	3	1088	2	machete
manchet	14	33	1777	2	manchet
naches	11	46	2241	2	naches
packet	14	47	2650	2	packet
rachets	12	45	1683	2	rachets
racket	12	52	2942	2	racket
ratchet	12	42	1833	2	ratchet
rochet	11	54	2300	2	rochet
sachem	13	40	1222	2	sachem
sachets	12	39	1410	2	sachets
tacet	7	58	4002	2	tac_et
tache	10	62	2237	2	tache_
taches	11	42	2417	2	taches
tacket	12	46	2749	2	tacket
yacht	13	4	1739	2	yach_t

Search took 3 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.110	1624463.6
2	DLD Change Limit	82551	58	2.703	30540.5
3	Display Results	58	58	0.016	3625.0
	(SQL Overall)	178691	58	2.829	63164.0