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

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

65 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
batchers	15	36	1327	(None)
batcher	14	44	1485	1	batcher_
batches	14	40	1961	1	batche_s
bathers	12	47	2036	1	bat_hers
botchers	15	35	1154	1	botchers
butchers	15	37	1018	1	butchers
catchers	15	31	1406	1	catchers
hatchers	16	31	1317	1	hatchers
matchers	15	30	1243	1	matchers
patchers	15	34	1330	1	patchers
watchers	16	35	1179	1	watchers
archers	12	44	1457	2	_archers
baches	13	54	2694	2	ba_che_s
backers	15	38	2188	2	ba_ckers
bashers	12	48	2083	2	ba_shers
batched	15	41	1424	2	batche_d
bather	11	53	2251	2	bat_her_
bathes	11	65	2483	2	bat_he_s
batters	9	46	2601	2	bat_ters
battlers	10	41	1097	2	battlers
belchers	15	35	1002	2	belchers
benchers	15	36	1101	2	benchers
bitchery	18	23	656	2	bitchery
bitches	14	41	1706	2	bitche_s
blanchers	16	30	743	2	blanchers
blathers	13	47	1379	2	blat_hers
bluchers	15	35	903	2	bluchers
botcher	14	36	1322	2	botcher_
botchery	18	36	676	2	botchery
botches	14	37	1602	2	botche_s
bothers	12	43	1775	2	bot_hers
butcher	14	34	1116	2	butcher_
butchery	18	32	625	2	butchery
butches	14	43	1536	2	butche_s
catcher	14	31	1582	2	catcher_
catches	14	43	2077	2	catche_s
ditchers	14	36	1036	2	ditchers
etchers	12	34	1129	2	_etchers
fathers	13	39	1650	2	fat_hers
fetchers	16	32	886	2	fetchers
gathers	11	43	1507	2	gat_hers
hatchels	16	36	867	2	hatchels
hatcher	15	33	1472	2	hatcher_
hatchery	19	32	638	2	hatchery
hatches	15	34	2027	2	hatche_s
hatchets	16	33	1038	2	hatchets
hitchers	16	37	999	2	hitchers
latches	12	33	2012	2	latche_s
latchets	13	34	1001	2	latchets
lathers	10	43	2188	2	lat_hers
marchers	15	37	1081	2	marchers
matcher	14	32	1428	2	matcher_
matches	14	32	1978	2	matche_s
notchers	13	27	942	2	notchers
patcher	14	35	1514	2	patcher_
patches	14	33	2038	2	patche_s
pitchers	15	32	1148	2	pitchers
ranchers	13	33	1179	2	ranchers
ratches	12	36	2046	2	ratche_s
ratchets	13	31	1026	2	ratchets
satchels	13	32	816	2	satchels
snatchers	14	14	631	2	snatchers
thatchers	17	4	458	2	thatchers
watcher	15	31	1340	2	watcher_
watches	15	30	1737	2	watche_s

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.143	1249587.4
2	DLD Change Limit	121059	65	3.716	32577.8
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	3.875	46113.8