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

Here are the results of your fuzzy-string dictionary search for “cachexy” with Change Limit: [1] [2] [3] [4]

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.

79 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
cachexy	24	4	328	(None)
cache	12	51	2248	2	cache__
cached	14	54	1920	2	cache_d
caches	13	79	2691	2	cache_s
cachet	13	45	2641	2	cache_t
cachets	14	50	1426	2	cachets
cachexia	22	6	358	2	cachexia
cachexic	21	5	354	2	cachexic
ache	9	68	2982	3	_ache__
ached	11	92	2783	3	_ache_d
achene	11	3	1381	3	_achene
aches	10	61	3229	3	_ache_s
achy	12	63	1609	3	_ach__y
alchemy	17	4	311	3	alchemy
archery	15	47	806	3	archery
bached	14	55	1989	3	bache_d
baches	13	54	2694	3	bache_s
cachepot	17	4	499	3	cachepot
cacheted	16	14	823	3	cacheted
cachexias	23	6	338	3	cachexias
cachexies	23	6	416	3	cachexies
caching	15	63	1750	3	caching
cachou	13	3	1062	3	cach_ou
cachous	14	3	1258	3	cachous
cagey	11	59	1782	3	ca_ge_y
cakey	14	55	1727	3	ca_ke_y
cannery	12	36	1001	3	cannery
carex	14	48	2230	3	ca_rex_
carney	11	53	1570	3	carne_y
casefy	14	3	627	3	ca_sefy
cashed	12	51	2435	3	cashe_d
cashes	11	47	2988	3	cashe_s
cashew	14	43	1145	3	cashe_w
cashews	15	42	860	3	cashews
catcher	14	31	1582	3	catche_r
catchers	15	31	1406	3	catchers
catches	14	43	2077	3	catche_s
catchfly	21	4	333	3	catchfly
catchy	16	55	958	3	catch__y
cathead	13	3	875	3	cathead
cathect	14	3	986	3	cathect
cathexes	20	3	627	3	cathexes
cathexis	20	4	575	3	cathexis
cattery	12	38	1160	3	cattery
caudex	16	3	640	3	caudex_
causey	11	35	1327	3	cause_y
cautery	12	34	959	3	cautery
chevy	16	47	999	3	__chevy
chewy	16	50	1190	3	__chewy
cicely	13	3	883	3	cic_ely
coached	15	33	1384	3	coache_d
coacher	14	37	1412	3	coache_r
coachers	15	43	1230	3	coachers
coaches	14	40	1869	3	coache_s
cutchery	18	26	517	3	cutchery
cyclery	17	6	349	3	cyclery
gauchely	17	4	274	3	gauchely
hatchery	19	32	638	3	hatchery
lacey	10	58	2091	3	lac_e_y
laches	11	65	2835	3	lache_s
lackey	15	48	1335	3	lacke_y
lathery	13	39	1112	3	lathery
lechery	15	25	764	3	lechery
mache	12	59	2530	3	mache__
maches	13	48	2723	3	mache_s
machete	14	3	1088	3	machete
naches	11	46	2241	3	nache_s
ochery	14	31	944	3	_ochery
pacey	12	67	2028	3	pac_e_y
rachet	11	50	2897	3	rache_t
rachets	12	45	1683	3	rachets
rackety	16	49	911	3	rackety
sachem	13	40	1222	3	sache_m
sachems	14	34	890	3	sachems
sachet	11	47	2577	3	sache_t
sachets	12	39	1410	3	sachets
tache	10	62	2237	3	tache__
taches	11	42	2417	3	tache_s
tackey	15	46	1308	3	tacke_y

Search took 7 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	134027	0.406	440125.6
2	DLD Change Limit	134027	79	5.953	22514.2
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	6.389	27968.5