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

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

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
summaries	13	11	818	(None)
summarise	13	11	573	1	summarise
summarises	14	11	525	1	summarises
summarizes	23	12	565	1	summarizes
mummeries	12	4	724	2	mummeries
submarines	14	4	691	2	submarines
sudaries	9	3	1275	2	su_daries
summarily	16	4	383	2	summarily
summarised	15	12	391	2	summarised
summarist	13	11	676	2	summarist
summarists	14	10	470	2	summarists
summarize	22	10	565	2	summarize
summarized	24	11	491	2	summarized
summarizer	23	10	427	2	summarizer
summarizers	24	13	282	2	summarizers
summates	12	26	1049	2	summa_tes
summerier	13	4	642	2	summerier
summeriest	14	7	608	2	summeriest
summitries	14	4	464	2	summitries
ambaries	12	33	1238	3	_ambaries
bursaries	11	5	764	3	bursaries
cumarins	12	3	864	3	cu_marins
dummies	12	30	1213	3	dumm__ies
flummeries	17	4	376	3	flummeries
gramaries	12	12	830	3	gramaries
hymnaries	17	5	431	3	hymnaries
luminaries	12	4	659	3	luminaries
mummies	10	38	1284	3	mumm__ies
mummifies	15	4	371	3	mummifies
primaries	13	4	1083	3	primaries
quinaries	18	5	787	3	quinaries
rummages	13	4	493	3	rumma_ges
rummies	11	32	1279	3	rumm__ies
salaries	8	3	1957	3	s_alaries
sectaries	11	3	1224	3	sectaries
seminaries	12	4	1000	3	seminaries
smarties	10	3	1287	3	s__marties
smearier	10	3	695	3	s_mearier
smeariest	11	3	811	3	s_meariest
spermaries	14	6	806	3	spermaries
stemmeries	14	4	517	3	stemmeries
submarine	13	4	784	3	submarine
submarined	15	4	450	3	submarined
submariner	14	4	407	3	submariner
submariners	15	5	322	3	submariners
submarket	17	9	608	3	submarket
submarkets	18	12	315	3	submarkets
submerges	14	4	628	3	submerges
submerses	13	4	800	3	submerses
subseries	11	3	1293	3	subseries
succories	13	4	718	3	succories
suffaris	14	4	508	3	suffari_s
sugarier	9	3	739	3	su_garier
sugariest	10	3	813	3	su_gariest
summable	14	3	690	3	summable_
summae	10	39	1101	3	summa__e_
summands	13	4	471	3	summa_nds
summary	14	29	735	3	summar__y
summas	10	43	1316	3	summa___s
summate	11	36	1166	3	summa_te_
summated	13	29	883	3	summa_ted
summating	14	3	794	3	summating
summation	13	4	780	3	summation
summations	14	5	678	3	summations
summative	16	4	620	3	summative
summered	13	3	814	3	summer_ed
summering	14	5	875	3	summering
summers	11	36	1650	3	summer__s
summerset	13	4	725	3	summerset
summersets	14	4	332	3	summersets
summertimes	14	5	286	3	summertimes
summits	11	3	798	3	summ__its
summonses	13	4	454	3	summonses
sundries	9	3	1202	3	su_ndries
surgeries	10	3	1136	3	surgeries
symmetries	17	4	566	3	symmetries
sympatries	17	4	467	3	sympatries
tummies	11	30	1203	3	tumm__ies
turbaries	11	4	774	3	turbaries
yummies	14	35	953	3	yumm__ies

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	148641	0.156	1145455.1
2	DLD Change Limit	148641	80	7.686	19339.2
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	7.872	22699.6