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

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

70 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
vetches	15	34	1126	(None)
etches	11	42	1776	1	_etches
fetches	15	34	1389	1	fetches
ketches	16	40	1219	1	ketches
kvetches	20	5	358	1	kvetches
letches	12	40	1548	1	letches
retches	12	33	1851	1	retches
aitches	12	30	1436	2	aitches
batches	14	40	1961	2	batches
beaches	14	41	2065	2	beaches
beeches	14	34	1388	2	beeches
belches	14	35	1434	2	belches
benches	14	39	1860	2	benches
bitches	14	41	1706	2	bitches
botches	14	37	1602	2	botches
butches	14	43	1536	2	butches
catches	14	43	2076	2	catches
cutches	14	32	1645	2	cutches
detaches	14	3	965	2	detaches
ditches	13	32	1571	2	ditches
eches	10	63	2216	2	_e_ches
etched	12	36	1370	2	_etched
etcher	11	39	1294	2	_etcher
etchers	12	34	1129	2	_etchers
fetched	16	37	1047	2	fetched
fetcher	15	35	1039	2	fetcher
fetchers	16	32	886	2	fetchers
fetiches	16	3	695	2	fetiches
fitches	15	35	1619	2	fitches
fletches	16	30	885	2	fletches
hatches	15	34	2027	2	hatches
hitches	15	36	1627	2	hitches
hotches	15	38	1436	2	hotches
hutches	15	36	1352	2	hutches
itches	11	49	1621	2	_itches
kenches	16	39	1227	2	kenches
kvetched	21	4	278	2	kvetched
kvetcher	20	5	281	2	kvetcher
kvetchers	21	4	237	2	kvetchers
latches	12	33	2012	2	latches
leaches	12	33	1934	2	leaches
leches	11	54	2131	2	le_ches
leeches	12	39	1193	2	leeches
letched	13	39	1205	2	letched
lethes	9	48	1808	2	let_hes
matches	14	32	1978	2	matches
merches	14	40	1376	2	merches
mutches	14	33	1428	2	mutches
notches	12	35	1365	2	notches
patches	14	33	2038	2	patches
peaches	14	41	2005	2	peaches
perches	14	37	1795	2	perches
pitches	14	36	1775	2	pitches
ratches	12	36	2046	2	ratches
reaches	12	34	2320	2	reaches
retched	13	38	1427	2	retched
rotches	12	35	1570	2	rotches
seiches	12	5	1381	2	seiches
sketches	17	4	682	2	sketches
teaches	12	27	1835	2	teaches
tenches	12	35	1552	2	tenches
tetched	13	30	1077	2	tetched
vetch	13	44	1184	2	vetch__
vetoes	9	29	1408	2	vet_oes
vouches	15	39	1411	2	vouches
watches	15	30	1737	2	watches
welches	15	37	1031	2	welches
wenches	15	29	1413	2	wenches
witches	15	27	1579	2	witches
wretches	16	25	728	2	wretches

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	107671	0.283	631417.0
2	DLD Change Limit	107671	70	4.936	21813.4
3	Display Results	70	70	0.046	1521.7
	(SQL Overall)	178691	70	5.265	33939.4