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

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

72 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
dignitaries	13	5	329	(None)
dignities	11	4	959	2	dignit__ies
dietaries	10	4	1066	3	di__etaries
digitalins	12	5	402	3	dig_italins
digitalis	11	4	496	3	dig_itali_s
digitalises	13	5	450	3	dig_italises
digitalizes	22	4	567	3	dig_italizes
dignifies	14	4	636	3	digni__fies
dignitary	14	4	246	3	dignitar__y
militaries	12	4	944	3	mi_litaries
pituitaries	13	5	300	3	pituitaries
sanitaries	10	4	991	3	_sanitaries
signatories	12	5	363	3	signatories
signiories	11	4	430	3	signi_ories
bigotries	12	8	644	4	big_ot_ries
binaries	10	3	1418	4	bi_n__aries
dataries	9	3	1403	4	d___ataries
denitrates	11	6	951	4	d_enitrates
depositaries	15	5	311	4	depositaries
diaries	8	33	2195	4	d___i_aries
dictionaries	15	5	478	4	dictionaries
digamies	12	3	864	4	dig___amies
digastrics	14	4	264	4	digast_rics
digitalin	11	5	410	4	dig_itali_n
digitalize	21	4	586	4	dig_italize
digitalized	23	4	531	4	dig_italized
digitals	10	4	543	4	dig_ita__ls
digitate	10	9	868	4	dig_ita_te_
digitated	12	8	696	4	dig_ita_ted
digitizes	20	4	692	4	dig_it_izes
digitonins	12	13	321	4	dig_itonins
digitoxins	19	11	240	4	dig_itoxins
dignified	15	4	557	4	digni__fied
dimities	11	3	1400	4	di_mit__ies
directories	14	4	602	4	directories
disunities	11	7	779	4	disunit__ies
dittanies	10	4	573	4	di__ttanies
divinities	14	4	774	4	divinit__ies
dormitories	14	6	368	4	dormitories
gyniatries	14	4	297	4	_gyniatries
ignifies	12	7	756	4	_igni__fies
ignimbrites	16	5	77	4	_ignimbrites
ignitable	12	4	546	4	_ignitable_
igniters	9	12	623	4	_igniter__s
ignites	8	13	1058	4	_ignit___es
ignitors	9	13	551	4	_ignitor__s
ignitrons	10	4	299	4	_ignit_rons
indignities	13	4	532	4	indignit__ies
janisaries	17	4	478	4	_janisaries
janizaries	26	4	350	4	_janizaries
laniaries	9	4	1122	4	_lani_aries
lienteries	10	4	757	4	lien_teries
lignifies	13	4	626	4	ligni__fies
lignites	9	12	961	4	lignit___es
militarise	12	8	686	4	mi_litarise
militarises	13	6	650	4	mi_litarises
militarizes	22	4	593	4	mi_litarizes
milliaries	12	4	824	4	milli_aries
miniseries	12	4	675	4	mi_niseries
ministries	12	4	756	4	mi_nistries
monitories	12	4	889	4	_monitories
niteries	8	3	1838	4	___niteries
notaries	8	3	1493	4	___notaries
planetaries	13	4	594	4	planetaries
sagittaries	12	5	299	4	sagittaries
seigniories	12	5	283	4	seigni_ories
signatures	11	5	352	4	signatur_es
signifies	13	4	706	4	signi__fies
signories	10	10	785	4	sign__ories
solitaries	10	4	1012	4	_solitaries
termitaries	13	4	569	4	termitaries
vanitories	13	4	691	4	_vanitories

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.436	409841.7
2	DLD Change Limit	148819	72	8.766	16976.8
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	9.232	19355.6