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

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

64 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
marched	15	38	1340	(None)
arched	12	57	1732	1	_arched
marchen	14	33	1207	1	marchen
marcher	14	39	1297	1	marcher
marches	14	39	2117	1	marches
matched	15	35	1396	1	matched
parched	15	40	1369	1	parched
ached	11	92	2783	2	_a_ched
arced	8	82	2416	2	_arc_ed
archer	11	50	1624	2	_archer
arches	11	48	2204	2	_arches
arcked	13	62	1194	2	_arcked
bached	14	55	1989	2	ba_ched
batched	15	41	1424	2	batched
birched	15	34	991	2	birched
cached	14	54	1920	2	ca_ched
earthed	11	3	992	2	earthed
farced	12	52	1653	2	farc_ed
hatched	16	34	1446	2	hatched
inarched	14	8	611	2	inarched
larchen	12	47	963	2	larchen
larches	12	44	1645	2	larches
latched	13	39	1407	2	latched
lurched	13	35	803	2	lurched
maced	10	85	2869	2	ma_c_ed
mache	12	59	2530	2	ma_che_
maches	13	48	2723	2	ma_ches
macled	11	67	1811	2	ma_cled
manche	13	35	1510	2	manche_
manches	14	38	1862	2	manches
manchet	14	33	1778	2	manchet
marbled	12	32	1211	2	marbled
marcel	10	37	1485	2	marc_el
march	12	56	2289	2	march__
marchers	15	37	1081	2	marchers
marchesa	15	34	688	2	marchesa
marchese	15	35	891	2	marchese
marchesi	15	33	732	2	marchesi
marked	13	39	2162	2	mar_ked
marled	9	55	2316	2	mar_led
marred	9	54	2104	2	mar_red
married	10	47	1530	2	married
marshes	12	36	1537	2	marshes
marted	9	44	2521	2	mar_ted
mashed	12	53	2504	2	ma_shed
matcher	14	32	1428	2	matcher
matches	14	32	1978	2	matches
merches	14	40	1376	2	merches
miched	14	39	1339	2	m_iched
mooched	15	39	1053	2	mooched
morphed	15	3	713	2	morphed
mouched	15	36	1259	2	mouched
mulched	15	30	776	2	mulched
munched	15	34	1107	2	munched
parches	14	37	2000	2	parches
patched	15	35	1462	2	patched
perched	15	47	1324	2	perched
ranched	13	31	1360	2	ranched
searched	14	20	925	2	searched
smirched	16	3	467	2	smirched
starched	14	19	931	2	starched
torched	13	35	1136	2	torched
unarched	14	12	855	2	unarched
watched	16	30	1282	2	watched

Search took 10 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.810	220606.2
2	DLD Change Limit	107671	64	8.376	12854.7
3	Display Results	64	64	0.016	4000.0
	(SQL Overall)	178691	64	9.202	19418.7