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

Here are the results of your fuzzy-string dictionary search for “scratchers” with Change Limit: [1] [2] [3] [4]

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.

76 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
scratchers	17	4	429	(None)
scratcher	16	3	544	1	scratcher_
scratches	16	4	732	1	scratche_s
catchers	15	31	1406	2	_c_atchers
cratches	15	30	1254	2	_cratche_s
schatchens	20	4	268	2	schatchens
scratched	17	3	539	2	scratche_d
scratchier	17	4	434	2	scratchier_
screechers	17	14	368	2	screechers
scutchers	16	17	564	2	sc_utchers
snatchers	14	14	631	2	s_natchers
stretchers	15	4	517	2	stretchers
batchers	15	36	1327	3	__batchers
catcher	14	31	1582	3	_c_atcher_
catches	14	43	2077	3	_c_atche_s
coachers	15	43	1230	3	_coa_chers
crackers	16	41	1172	3	_cra_ckers
cranches	15	31	1454	3	_cranche_s
crashers	13	40	1323	3	_cra_shers
craters	9	50	2189	3	_crat__ers
crotches	15	34	1130	3	_crotche_s
crotchets	16	39	630	3	_crotchets
crunchers	16	31	624	3	_crunchers
crutches	15	35	959	3	_crutche_s
hatchers	16	31	1317	3	__hatchers
matchers	15	30	1243	3	__matchers
patchers	15	34	1330	3	__patchers
ranchers	13	33	1179	3	__ranchers
ratches	12	36	2046	3	__ratche_s
ratchets	13	31	1026	3	__ratchets
satchels	13	32	816	3	s__atchels
scathes	12	45	1571	3	sc_at_he_s
scatters	10	36	1275	3	sc_at_ters
schatchen	19	4	385	3	schatche_n
scootches	16	3	500	3	scootche_s
scorchers	16	14	551	3	sc_orchers
scotches	15	17	947	3	sc_otche_s
scouthers	14	4	599	3	scout_hers
scrabblers	16	21	381	3	scrabblers
scraiched	17	4	420	3	scraiche_d
scraichs	15	4	399	3	scraich__s
scramblers	16	18	354	3	scramblers
scrapers	12	55	1053	3	scra__pers
scrappers	15	4	586	3	scra_ppers
scratch	14	4	601	3	scratch___
scratchiest	18	4	414	3	scratchiest
scratchily	20	4	255	3	scratchily
scratchiness	19	6	238	3	scratchiness
scratching	18	4	453	3	scratching
scratchy	18	4	365	3	scratch__y
scrawlers	14	3	475	3	scra_wlers
screecher	16	14	448	3	screecher_
screeches	16	9	565	3	screeche_s
scrooches	16	4	570	3	scrooche_s
scrootches	17	4	332	3	scrootche_s
scrunches	16	3	540	3	scrunche_s
scultches	16	6	429	3	scultche_s
scutcher	15	17	696	3	sc_utcher_
scutches	15	16	888	3	sc_utche_s
searchers	14	19	735	3	s_earchers
sheathers	15	5	755	3	sheat_hers
sketchers	18	3	451	3	s_ketchers
slatches	13	15	1152	3	s_latche_s
slathers	11	39	1478	3	s_lat_hers
snatcher	13	16	776	3	s_natcher_
snatches	13	14	1071	3	s_natche_s
snitchers	14	16	604	3	s_nitchers
stanchers	14	20	681	3	s_tanchers
stitchers	14	14	701	3	s_titchers
stretcher	14	4	629	3	stretcher_
stretches	14	3	829	3	stretche_s
swatches	16	16	996	3	s_watche_s
swathers	14	45	1208	3	s_wat_hers
switchers	17	14	663	3	s_witchers
thatchers	17	4	458	3	_thatchers
watchers	16	35	1179	3	__watchers

Search took 8 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	140603	0.423	422437.4
2	DLD Change Limit	140603	76	6.813	20637.5
3	Display Results	76	76	0.046	1652.2
	(SQL Overall)	178691	76	7.282	24538.7