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

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

80 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
summarizers	24	13	282	(None)
summarizer	23	10	427	1	summarizer_
summarizes	23	12	565	1	summarize_s
submariners	15	5	322	2	submariners
summaries	13	11	818	2	summari_e_s
summarises	14	11	525	2	summarise_s
summarize	22	10	565	2	summarize__
summarized	24	11	491	2	summarize_d
humanizers	24	4	395	3	hu_manizers
submariner	14	4	407	3	submariner_
submarines	14	4	691	3	submarine_s
summarise	13	11	573	3	summarise__
summarised	15	12	391	3	summarise_d
summarists	14	10	470	3	summari_sts
summarizing	25	4	458	3	summarizing
summerier	13	4	642	3	summeri_er_
vulgarizers	24	17	247	3	vulgarizers
authorizers	23	5	302	4	authorizers
curarizes	20	7	817	4	cu_rarize_s
dogmatizers	24	5	258	4	dogmatizers
formalizers	25	25	538	4	formalizers
glamorizers	23	10	270	4	glamorizers
humanizer	23	4	572	4	hu_manizer_
humanizes	23	4	753	4	hu_manize_s
immunizers	23	5	284	4	_immunizers
lemmatizes	23	4	501	4	lemmatize_s
mariners	10	31	1386	4	___mariners
memorizers	23	12	500	4	_memorizers
mesmerizers	24	5	265	4	mesmerizers
mummeries	12	4	724	4	mummeri_e_s
normalizers	22	21	477	4	normalizers
polarizers	21	6	589	4	_polarizers
pulverizers	25	5	224	4	pulverizers
rummagers	14	4	303	4	rumma__gers
satirizers	19	4	395	4	s_atirizers
secularizers	23	17	324	4	secularizers
sermonizers	22	15	404	4	sermonizers
smearers	10	30	862	4	s_mear__ers
smearier	10	3	695	4	s_meari_er_
socializers	22	4	379	4	socializers
solarizes	18	5	1161	4	s_olarize_s
sommeliers	14	4	267	4	sommeli_ers
suberizes	20	8	1183	4	su_berize_s
submanagers	16	5	170	4	submanagers
submarine	13	4	784	4	submarine__
submarined	15	4	450	4	submarine_d
submarkets	18	12	315	4	submar_kets
subscribers	17	5	261	4	subscribers
subsidizers	23	5	288	4	subsidizers
subwriters	15	4	441	4	su_bwriters
sudaries	9	3	1275	4	su_dari_e_s
sugarers	9	3	630	4	su_gar__ers
sugarier	9	3	739	4	su_gari_er_
sulfurizes	22	4	409	4	sulfurize_s
summarily	16	4	383	4	summari__ly
summarising	16	5	356	4	summarising
summarist	13	11	676	4	summari__st
summarizable	27	6	137	4	summarizable
summates	12	26	1049	4	summa__te_s
summations	14	5	678	4	summati_ons
summative	16	4	620	4	summative__
summeriest	14	7	608	4	summeri_est
summers	11	36	1650	4	summ____ers
summersets	14	4	332	4	summer_sets
summertimes	14	5	286	4	summertime_s
summiteers	14	4	234	4	summ_iteers
summitries	14	4	464	4	summitri_e_s
summoners	13	4	473	4	summ__oners
surmisers	11	4	520	4	surm__isers
surprisers	12	4	363	4	su_rprisers
surprizes	20	4	559	4	su_rprize_s
sustainers	10	4	413	4	susta_iners
symbolizers	27	7	225	4	symbolizers
symmetrizes	27	5	375	4	symmetrize_s
sympathizers	31	6	180	4	sympathizers
temporizers	24	4	373	4	temporizers
vulcanizers	25	5	245	4	vulcanizers
vulgarizer	23	14	376	4	vulgarizer_
vulgarizes	23	14	520	4	vulgarize_s
womanizers	24	4	417	4	_womanizers

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.420	425454.8
2	DLD Change Limit	148819	80	8.923	16678.1
3	Display Results	80	80	0.046	1739.1
	(SQL Overall)	178691	80	9.389	19032.0