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

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

75 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
merches	14	40	1376	(None)
marches	14	39	2117	1	marches
merces	10	57	2074	1	merc_es
mercies	11	38	1756	1	mercies
perches	14	37	1795	1	perches
amerces	11	4	985	2	amerc_es
arches	11	48	2204	2	_arches
beaches	14	41	2065	2	beaches
beeches	14	34	1388	2	beeches
belches	14	35	1434	2	belches
benches	14	39	1860	2	benches
birches	14	34	1232	2	birches
creches	14	3	1309	2	creches
curches	14	35	1274	2	curches
eches	10	63	2216	2	_e_ches
etches	11	42	1776	2	_etches
fetches	15	34	1389	2	fetches
kenches	16	39	1227	2	kenches
ketches	16	40	1219	2	ketches
larches	12	44	1645	2	larches
leaches	12	33	1934	2	leaches
leches	11	54	2131	2	le_ches
leeches	12	39	1193	2	leeches
letches	12	40	1548	2	letches
lurches	12	33	1166	2	lurches
maches	13	48	2723	2	m_aches
manches	14	38	1862	2	manches
marched	15	38	1340	2	marched
marchen	14	33	1207	2	marchen
marcher	14	39	1297	2	marcher
marchers	15	37	1081	2	marchers
marchesa	15	34	688	2	marchesa
marchese	15	35	891	2	marchese
marchesi	15	33	732	2	marchesi
marshes	12	36	1537	2	marshes
matches	14	32	1978	2	matches
menarches	16	4	668	2	menarches
mensches	15	3	630	2	mensches
menshes	12	3	1045	2	menshes
mercer	10	52	1420	2	merc_er
mercers	11	44	1277	2	mercers
merch	12	54	1796	2	merch__
mercs	9	60	2045	2	merc__s
merdes	9	45	1860	2	mer_des
meres	7	51	4357	2	mer__es
mergees	10	44	1123	2	mergees
merges	9	41	2249	2	mer_ges
merises	9	34	2142	2	merises
merles	8	53	2276	2	mer_les
meshes	11	50	1944	2	me_shes
miches	13	43	2073	2	m_iches
mooches	14	37	1445	2	mooches
mouches	14	38	1596	2	mouches
muches	13	47	1899	2	m_uches
mulches	14	32	1067	2	mulches
munches	14	42	1579	2	munches
mutches	14	33	1428	2	mutches
parches	14	37	2000	2	parches
peaches	14	41	2005	2	peaches
perched	15	47	1324	2	perched
percher	14	33	1342	2	percher
perchers	15	36	1152	2	perchers
porches	14	38	1567	2	porches
reaches	12	34	2320	2	reaches
retches	12	33	1851	2	retches
searches	13	21	1290	2	searches
seiches	12	5	1381	2	seiches
smirches	15	3	599	2	smirches
teaches	12	27	1835	2	teaches
tenches	12	35	1552	2	tenches
terces	8	39	2141	2	terc_es
torches	12	37	1544	2	torches
vetches	15	34	1126	2	vetches
welches	15	37	1031	2	welches
wenches	15	29	1413	2	wenches

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.390	458182.1
2	DLD Change Limit	107671	75	3.486	30886.7
3	Display Results	75	75	0.013	5769.2
	(SQL Overall)	178691	75	3.889	45947.8