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

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

52 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
fetchers	16	32	886	(None)
etchers	12	34	1129	1	_etchers
fetcher	15	35	1039	1	fetcher_
fetches	15	34	1389	1	fetche_s
fletchers	17	33	553	1	fletchers
aethers	10	36	1494	2	aet_hers
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
etcher	11	39	1294	2	_etcher_
etches	11	42	1776	2	_etche_s
ethers	9	45	1841	2	_et_hers
fathers	13	39	1650	2	fat_hers
feathers	14	35	1324	2	feathers
fencers	12	38	1062	2	fenc_ers
fetched	16	37	1047	2	fetche_d
fetiches	16	3	695	2	fetiche_s
fetters	10	35	1790	2	fet_ters
filchers	16	28	686	2	filchers
fitches	15	35	1619	2	fitche_s
fitchets	16	30	741	2	fitchets
fitchews	19	27	477	2	fitchews
fletcher	16	30	666	2	fletcher_
fletches	16	30	885	2	fletche_s
hatchers	16	31	1317	2	hatchers
hitchers	16	37	999	2	hitchers
ketches	16	40	1219	2	ketche_s
kvetchers	21	4	237	2	kvetchers
leachers	13	37	1281	2	leachers
lechers	12	33	1396	2	le_chers
letches	12	40	1548	2	letche_s
matchers	15	30	1243	2	matchers
notchers	13	27	942	2	notchers
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	tet_hers
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	121059	0.373	479064.3
2	DLD Change Limit	121059	52	3.423	35366.3
3	Display Results	52	52	0.016	3250.0
	(SQL Overall)	178691	52	3.812	46875.9