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

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

53 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
etchers	12	34	1129	(None)
etcher	11	39	1294	1	etcher_
etches	11	42	1776	1	etche_s
ethers	9	45	1841	1	et_hers
fetchers	16	32	886	1	fetchers
aethers	10	36	1494	2	aet_hers
archers	12	44	1457	2	archers
batchers	15	36	1327	2	batchers
belchers	15	35	1002	2	belchers
benchers	15	36	1101	2	benchers
botchers	15	35	1154	2	botchers
butchers	15	37	1018	2	butchers
catchers	15	31	1406	2	catchers
detachers	15	3	648	2	detachers
ditchers	14	36	1036	2	ditchers
eches	10	63	2216	2	e_che_s
echoers	12	45	969	2	e_choers
eschars	12	3	717	2	eschars
eschews	15	3	455	2	eschews
etched	12	36	1370	2	etche_d
ether	8	45	1877	2	et_her_
euchres	12	8	866	2	euchres
fetcher	15	35	1039	2	fetcher_
fetches	15	34	1389	2	fetche_s
fletchers	17	33	553	2	fletchers
hatchers	16	31	1317	2	hatchers
hitchers	16	37	999	2	hitchers
inchers	12	39	1252	2	inchers
itches	11	49	1621	2	itche_s
ketches	16	40	1219	2	ketche_s
kvetchers	21	4	237	2	kvetchers
leachers	13	37	1281	2	leachers
lechers	12	33	1396	2	lechers
letches	12	40	1548	2	letche_s
matchers	15	30	1243	2	matchers
notchers	13	27	942	2	notchers
ochers	11	39	1530	2	_ochers
others	9	39	1800	2	ot_hers
patchers	15	34	1330	2	patchers
peachers	15	32	1384	2	peachers
perchers	15	36	1152	2	perchers
pitchers	15	32	1148	2	pitchers
reachers	13	35	1572	2	reachers
retches	12	33	1851	2	retche_s
sketchers	18	3	451	2	sketchers
teachers	13	32	1239	2	teachers
tethers	10	38	1531	2	tethers
tochers	12	34	1309	2	tochers
vetches	15	34	1126	2	vetche_s
watchers	16	35	1179	2	watchers
welchers	16	33	805	2	welchers
wenchers	16	31	921	2	wenchers
wethers	13	52	1469	2	wet_hers

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.140	1276364.3
2	DLD Change Limit	107671	53	3.390	31761.4
3	Display Results	53	53	0.016	3312.5
	(SQL Overall)	178691	53	3.546	50392.3