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

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

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.

62 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
catechizers	27	5	223	(None)
catechizer	26	4	314	1	catechizer_
catechizes	26	4	434	1	catechize_s
catechises	17	4	491	2	catechise_s
catechize	25	4	447	2	catechize__
catechized	27	4	347	2	catechize_d
catchers	15	31	1406	3	cat_ch__ers
catchier	15	32	986	3	cat_chi_er_
catecheses	17	4	381	3	catechese_s
catechins	16	4	664	3	catechi__ns
catechise	16	4	494	3	catechise__
catechised	18	4	311	3	catechise_d
catechisms	19	4	427	3	catechi_sms
catechists	17	4	446	3	catechi_sts
catechizing	28	5	397	3	catechizing
catechumens	20	5	134	3	catechumens
archaizers	24	4	363	4	_a_rchaizers
ateliers	8	3	788	4	_ate_li_ers
atomizers	20	26	555	4	_at_omizers
batchers	15	36	1327	4	bat_ch__ers
cahiers	12	35	1067	4	ca___hi_ers
caleches	15	26	993	4	calech__e_s
canonizers	21	4	441	4	ca_nonizers
caregivers	16	4	245	4	care_givers
cartelizes	21	4	763	4	carte_lize_s
cashiers	13	31	888	4	ca__shi_ers
catalyzers	24	4	305	4	cat_alyzers
catbriers	13	4	414	4	cat_bri_ers
catcallers	14	4	380	4	cat_callers
catcher	14	31	1582	4	cat_ch__er_
catches	14	43	2077	4	cat_ch__e_s
catchiest	16	3	831	4	cat_chi_est
catechesis	17	4	324	4	catech_esis
catechin	15	4	681	4	catechi___n
catechising	19	5	354	4	catechising
catechism	18	4	472	4	catechi__sm
catechismal	20	6	160	4	catechismal
catechist	16	5	680	4	catechi__st
catechistic	17	5	313	4	catechistic
catechols	16	5	505	4	catech__ols
catechumen	19	5	197	4	catechume_n
catechus	15	4	482	4	catech___us
categorizes	23	5	419	4	categorize_s
caterers	10	28	1440	4	cate___rers
catheters	14	3	701	4	cat__heters
cauterizes	21	9	799	4	caute_rize_s
criticizers	24	7	233	4	critic_izers
fraternizers	24	10	170	4	fraternizers
hatchers	16	31	1317	4	hat_ch__ers
itemizers	20	13	329	4	_ite_mizers
latecomers	14	4	282	4	latec_omers
laterizes	18	5	1301	4	late_rize_s
laticifers	15	4	246	4	latic_ifers
matchers	15	30	1243	4	mat_ch__ers
pasteurizers	23	5	176	4	pasteurizers
patchers	15	34	1330	4	pat_ch__ers
patchier	15	31	966	4	pat_chi_er_
patchiness	17	4	493	4	pat_chiness
satirizers	19	4	395	4	sat_irizers
techier	12	6	924	4	__techi_er_
techies	12	5	1360	4	__techi_e_s
watchers	16	35	1179	4	wat_ch__ers

Search took 10 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	148819	0.423	422437.4
2	DLD Change Limit	148819	62	9.360	15899.5
3	Display Results	62	62	0.033	1878.8
	(SQL Overall)	178691	62	9.816	18204.1