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

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

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.

52 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
merchandisers	21	6	131	(None)
merchandiser	20	6	192	1	merchandiser_
merchandises	20	7	289	1	merchandise_s
merchandise	19	5	285	2	merchandise__
merchandised	21	5	214	2	merchandise_d
merchandizes	29	5	266	2	merchandize_s
mechanizers	27	5	353	3	me_chan_izers
merchandising	22	6	181	3	merchandising
merchandisings	23	7	104	3	merchandisings
merchandize	28	5	268	3	merchandize__
merchandized	30	5	231	3	merchandize_d
mechanisms	19	4	572	4	me_chan_is_ms
mechanists	17	4	589	4	me_chan_is_ts
mechanizer	26	4	504	4	me_chan_izer_
mechanizes	26	4	677	4	me_chan_ize_s
merchandizing	31	6	228	4	merchandizing
merchandizings	32	6	117	4	merchandizings
mergansers	13	4	224	4	mer_gan__sers
archaises	14	4	840	5	_archa__ise_s
archaizers	24	4	363	5	_archa__izers
chandlers	15	38	767	5	___chand_lers
chastisers	15	4	317	5	___chastisers
enchanters	15	4	522	5	_enchan__ters
enchasers	14	4	509	5	_encha___sers
eucharises	15	4	544	5	_eucha_rise_s
exchangers	23	10	320	5	_exchan__gers
germanders	14	4	460	5	ger_mand__ers
gormandises	15	6	374	5	gor_mandise_s
gormandizers	25	6	266	5	gor_mandizers
meanderers	13	4	380	5	me___anderers
meanders	11	6	883	5	me___and__ers
mechanicals	20	9	375	5	me_chan_icals
mechanics	18	4	598	5	me_chan_i__cs
mechanism	18	4	656	5	me_chan_is__m
mechanist	16	4	874	5	me_chan_is__t
mechanistic	20	5	437	5	me_chan_istic
mechanize	25	4	707	5	me_chan_ize__
mechanized	27	4	588	5	me_chan_ize_d
mercantile	14	5	351	5	merc_antile__
mercenaries	15	5	544	5	mercenari_e_s
mercenariness	17	6	258	5	mercenariness
mercerises	14	4	619	5	merc__erise_s
merchanted	18	4	448	5	merchan__te_d
merchanting	19	4	431	5	merchanti__ng
merchantmen	20	5	189	5	merchan_tme_n
merchants	16	4	622	5	merchan____ts
merganser	12	4	285	5	mer_gan__ser_
methodises	16	4	546	5	me_th_odise_s
mirandizes	22	4	412	5	mir__andize_s
orchardists	17	5	208	5	_orchardis_ts
organisers	11	4	362	5	_or_gan_isers
purchasers	17	4	255	5	purcha___sers

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	124790	0.390	458182.1
2	DLD Change Limit	124790	52	8.893	14032.4
3	Display Results	52	52	0.030	1733.3
	(SQL Overall)	178691	52	9.313	19187.3