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

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

45 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
marchers	15	37	1081	(None)
archers	12	44	1457	1	_archers
marcher	14	39	1297	1	marcher_
marches	14	39	2117	1	marche_s
matchers	15	30	1243	1	matchers
archer	11	50	1624	2	_archer_
archery	15	47	806	2	_archery
arches	11	48	2204	2	_arche_s
batchers	15	36	1327	2	batchers
catchers	15	31	1405	2	catchers
farcers	12	47	1344	2	farc_ers
hatchers	16	31	1317	2	hatchers
larches	12	44	1644	2	larche_s
lurchers	13	30	715	2	lurchers
macers	10	53	2127	2	ma_c_ers
maches	13	48	2723	2	ma_che_s
manches	14	38	1862	2	manche_s
manchets	15	26	957	2	manchets
marblers	12	31	923	2	marblers
marcels	11	32	1237	2	marc_els
marched	15	38	1340	2	marche_d
marchen	14	33	1207	2	marche_n
marchesa	15	34	688	2	marchesa
marchese	15	35	891	2	marchese
marchesi	15	33	732	2	marchesi
mariners	10	31	1386	2	mariners
markers	13	35	1610	2	mar_kers
markhors	17	4	539	2	markhors
marrers	9	34	1431	2	mar_rers
marriers	10	33	1247	2	marriers
marshes	12	36	1537	2	marshe_s
mashers	12	46	2105	2	ma_shers
matcher	14	32	1428	2	matcher_
matches	14	32	1978	2	matche_s
mercers	11	44	1277	2	merc_ers
merches	14	40	1376	2	merche_s
moochers	15	36	912	2	moochers
munchers	15	31	877	2	munchers
murthers	13	3	654	2	murthers
parches	14	37	2000	2	parche_s
patchers	15	34	1330	2	patchers
perchers	15	36	1152	2	perchers
ranchers	13	33	1179	2	ranchers
searchers	14	19	735	2	searchers
watchers	16	35	1179	2	watchers

Search took 6 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	121059	0.143	1249587.4
2	DLD Change Limit	121059	45	4.873	24842.8
3	Display Results	45	45	0.016	2812.5
	(SQL Overall)	178691	45	5.032	35510.9