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

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

72 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	1	cachet
mache	12	59	2530	1	mache_
maches	13	48	2723	1	maches
machete	14	3	1088	1	machete
manchet	14	33	1777	1	manchet
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
cache	12	51	2248	2	cache_
cached	14	54	1920	2	cached
caches	13	79	2691	2	caches
cachets	14	50	1426	2	cachets
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
mace	8	73	4578	2	mac_e_
maced	10	85	2869	2	mac_ed
macer	9	121	2694	2	mac_er
maces	9	71	3996	2	mac_es
mach	11	61	3447	2	mach__
machetes	15	3	963	2	machetes
macho	12	61	2015	2	mach_o
machos	13	52	1749	2	machos
machree	14	3	851	2	machree
machs	12	57	2256	2	mach_s
macle	9	61	2700	2	macle_
macled	11	67	1811	2	macled
macles	10	70	2322	2	macles
magnet	9	3	2066	2	magnet
maihem	13	6	621	2	maihem
mallet	8	44	3305	2	mallet
mammet	9	43	1925	2	mammet
manche	13	35	1510	2	manche_
manches	14	38	1862	2	manches
manchets	15	26	957	2	manchets
marched	15	38	1340	2	marched
marchen	14	33	1207	2	marchen
marcher	14	39	1297	2	marcher
marches	14	39	2117	2	marches
market	12	32	2604	2	market
mashed	12	53	2504	2	mashed
masher	11	41	2320	2	masher
mashes	11	50	3000	2	mashes
matched	15	35	1396	2	matched
matcher	14	32	1428	2	matcher
matches	14	32	1978	2	matches
maumet	10	35	1888	2	maumet
mayhem	16	4	492	2	mayhem
miche	12	62	1924	2	miche_
miched	14	39	1339	2	miched
miches	13	43	2073	2	miches
muches	13	47	1899	2	muches
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	72	2.750	30018.5
3	Display Results	72	72	0.033	2181.8
	(SQL Overall)	178691	72	2.893	61766.7