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

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

77 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
signatories	12	5	363	(None)
cosignatories	16	6	121	2	cosignatories
signatures	11	5	352	2	signatur_es
signiories	11	4	430	2	sign_iories
signories	10	10	785	2	sign__ories
dignitaries	13	5	329	3	dignitaries
seigniories	12	5	283	3	seign_iories
seignories	11	4	497	3	seign__ories
signatory	13	4	462	3	signator__y
signature	10	5	376	3	signatur_e_
sudatories	11	4	567	3	s_udatories
anatomies	11	15	969	4	__anatomies
bigotries	12	8	644	4	big_ot_ries
binaries	10	3	1418	4	bi_na__ries
crematories	15	4	685	4	crematories
designators	13	4	430	4	designator__s
dignities	11	4	959	4	dignit__ies
directories	14	4	601	4	directories
emunctories	15	5	267	4	emunctories
feudatories	15	5	371	4	feudatories
fumatories	15	4	473	4	_fumatories
gantries	9	14	1378	4	__gant_ries
histories	12	4	1247	4	hi__stories
ignatias	9	4	491	4	_ignat__ias
ignitors	9	13	551	4	_ignitor__s
ignores	8	26	900	4	_ign__or_es
lavatories	13	4	503	4	_lavatories
lienteries	10	4	756	4	lien_teries
ligatures	10	4	493	4	lig_atur_es
lignaloes	10	5	403	4	lignalo__es
mandatories	14	5	496	4	mandatories
midstories	13	4	565	4	mi_dstories
migrators	12	4	754	4	migrator__s
monitories	12	4	889	4	_monitories
nonstories	10	4	976	4	_nonstories
oratories	9	4	1064	4	__oratories
pinafores	14	4	450	4	pi_nafor_es
pronatores	12	4	737	4	pronator_es
purgatories	14	6	333	4	purgatories
rigatonis	10	4	450	4	rig_atoni_s
sagamores	12	4	418	4	sag_amor_es
sagittaries	12	5	299	4	sagittaries
salutatories	12	6	231	4	salutatories
sanatoria	9	4	714	4	s_anatori_a
sanatorium	12	4	532	4	s_anatorium
sanatoriums	13	5	351	4	s_anatoriums
sanitaries	10	4	991	4	s_anitaries
satoris	7	3	1725	4	s___atori_s
savories	11	3	1127	4	s___avories
secretories	13	4	594	4	secretories
seigneuries	12	5	257	4	seign_euries
senatorial	10	4	732	4	s_enatorial
senatorian	10	4	669	4	s_enatorian
senators	8	3	1295	4	s_enator__s
sentries	8	13	1805	4	s_en_t_ries
signages	10	3	748	4	signa___ges
signalers	10	4	458	4	signaler__s
signalise	10	4	639	4	signa__lise
signalises	11	4	591	4	signa_lises
signalizes	20	4	646	4	signa_lizes
signifies	13	4	706	4	sign__ifies
signiori	9	4	335	4	sign_iori__
signiors	9	4	492	4	sign_ior__s
signoras	9	30	655	4	sign__or_as
signore	8	32	909	4	sign__or_e_
signori	8	34	789	4	sign__ori__
signorina	10	4	396	4	sign__orina
signorinas	11	5	267	4	sign__orinas
signorine	10	4	517	4	sign__orine
signors	8	34	1091	4	sign__or__s
sinologies	11	4	889	4	si_nologies
stories	7	3	2427	4	s____tories
sympatries	17	4	468	4	sympat_ries
syntonies	12	4	815	4	s_yn_tonies
vanitories	13	4	690	4	_vanitories
viatores	11	25	768	4	vi__ator_es
victories	14	4	891	4	vi__ctories

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	77	9.080	16389.8
3	Display Results	77	77	0.046	1673.9
	(SQL Overall)	178691	77	9.549	18713.1