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

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

85 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
massagers	12	4	550	(None)
massager	11	3	687	1	massager_
massages	11	5	988	1	massage_s
assayers	11	4	484	2	_assayers
assuagers	10	4	346	2	_assuagers
managers	11	29	1100	2	ma_nagers
massacrers	14	4	227	2	massacrers
massacres	13	4	468	2	massacres
massage	10	3	989	2	massage__
massaged	12	3	675	2	massage_d
masseters	11	3	628	2	masseters
messages	11	3	823	2	message_s
passages	11	3	951	2	passage_s
amassers	10	33	783	3	amass__ers
assagais	9	4	381	3	_assagais
assailers	9	4	398	3	_assailers
assayer	10	3	557	3	_assayer_
assigners	10	4	441	3	_assigners
assuager	9	4	434	3	_assuager_
assuages	9	3	627	3	_assuage_s
assumers	10	6	496	3	_assumers
assurers	8	6	630	3	_assurers
asswages	12	5	505	3	_asswage_s
bandagers	13	3	588	3	bandagers
brassages	12	4	526	3	brassage_s
damagers	12	3	706	3	da_magers
embassages	15	5	183	3	embassage_s
essayers	11	3	356	3	_essayers
gassers	8	47	1463	3	gass__ers
gossamers	12	4	333	3	gossamers
laagers	8	34	1125	3	la__agers
lassoers	8	33	851	3	lass_oers
malingers	12	8	585	3	malingers
manager	10	34	1358	3	ma_nager_
manages	10	34	1896	3	ma_nage_s
mangers	10	35	2126	3	ma__ngers
manslayers	15	4	268	3	manslayers
mapmakers	19	4	404	3	mapmakers
masers	8	46	2345	3	ma_s__ers
mashers	12	46	2105	3	ma_s_hers
maskers	13	39	1383	3	ma_s_kers
masquers	19	19	570	3	ma_squers
massacre	12	4	474	3	massa_cre
massacred	14	4	319	3	massacred
massacrer	13	4	289	3	massacrer
massaging	13	4	635	3	massaging
massas	8	51	1646	3	massa___s
masses	8	50	2871	3	mass__e_s
masseter	10	3	706	3	masseter_
masseurs	10	3	492	3	mass_eurs
massier	9	36	1522	3	mass_ier_
massiness	11	28	1014	3	massiness
massless	10	27	711	3	mass_less
masters	9	46	2892	3	ma_s_ters
message	10	3	783	3	message__
messaged	12	3	554	3	message_d
messengers	13	4	290	3	messengers
messuages	12	4	439	3	messuage_s
misavers	13	4	805	3	m_isavers
mislayers	14	4	593	3	mislayers
mispages	13	3	1118	3	mispage_s
misshapers	17	4	339	3	misshapers
missteers	11	3	591	3	missteers
mistakers	15	11	707	3	mistakers
misusages	12	4	497	3	misusage_s
mossers	9	41	1619	3	moss__ers
naysayers	15	4	235	3	naysayers
packagers	18	14	468	3	packagers
passades	11	3	920	3	passade_s
passage	10	3	980	3	passage__
passaged	12	3	624	3	passage_d
passengers	13	4	321	3	passengers
passers	9	47	1775	3	pass__ers
passovers	14	14	475	3	passovers
presagers	12	3	694	3	presagers
rampagers	14	4	386	3	rampagers
ravagers	12	3	557	3	ra_vagers
salvagers	13	4	469	3	salvagers
sausages	9	3	700	3	sausage_s
stagers	8	41	1667	3	__stagers
swagers	11	42	1102	3	__swagers
tanagers	9	25	900	3	ta_nagers
upstagers	12	17	333	3	upstagers
wassailers	13	4	234	3	wassailers
wastages	12	10	975	3	wastage_s

Search took 7 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	85	6.766	21968.8
3	Display Results	85	85	0.033	2575.8
	(SQL Overall)	178691	85	6.955	25692.5