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

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

60 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
patchers	15	34	1330	(None)
batchers	15	36	1327	1	batchers
catchers	15	31	1405	1	catchers
hatchers	16	31	1317	1	hatchers
matchers	15	30	1243	1	matchers
patcher	14	35	1514	1	patcher_
patches	14	33	2038	1	patche_s
pitchers	15	32	1148	1	pitchers
watchers	16	35	1179	1	watchers
archers	12	44	1457	2	_archers
batcher	14	44	1485	2	batcher_
batches	14	40	1961	2	batche_s
bathers	12	47	2036	2	bat_hers
botchers	15	35	1154	2	botchers
butchers	15	37	1018	2	butchers
catcher	14	31	1582	2	catcher_
catches	14	43	2076	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	1506	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
pacers	10	51	2454	2	pa_c_ers
packers	15	38	1889	2	pa_ckers
panthers	13	5	1078	2	panthers
parches	14	37	2000	2	parche_s
patched	15	35	1462	2	patche_d
patchier	15	31	966	2	patchier_
paters	8	49	3582	2	pat__ers
patters	9	48	2519	2	pat_ters
patzers	18	42	1057	2	pat_zers
peachers	15	32	1384	2	peachers
perchers	15	36	1152	2	perchers
pinchers	15	35	1061	2	pinchers
pitcher	14	38	1371	2	pitcher_
pitches	14	36	1775	2	pitche_s
poachers	15	29	1076	2	poachers
pothers	12	38	1862	2	pot_hers
punchers	15	26	1007	2	punchers
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	630	2	snatchers
thatchers	17	4	457	2	thatchers
watcher	15	31	1340	2	watcher_
watches	15	30	1737	2	watche_s

Search took 7 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.156	1145455.1
2	DLD Change Limit	121059	60	5.673	21339.5
3	Display Results	60	60	0.046	1304.3
	(SQL Overall)	178691	60	5.875	30415.5