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

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

45 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
missionaries	14	5	362	(None)
visionaries	14	5	425	2	vi_sionaries
dictionaries	15	5	478	3	dictionaries
fissionables	17	5	215	3	fissionables
millionaires	14	7	299	3	millionaires
missileries	13	5	355	3	missi_leries
missilries	12	4	409	3	missi__lries
missiologies	15	5	331	3	missiologies
missionary	15	5	366	3	missionar__y
missioners	12	4	585	3	missioner__s
missionizes	22	12	379	3	mission_izes
pensionaries	14	5	406	3	pensionaries
billionaires	14	7	295	4	billionaires
cassowaries	16	8	228	4	cass_owaries
commissionaires	21	8	177	4	~~com~~missionaires
dissonances	14	5	427	4	diss_onances
emissaries	12	4	477	4	emiss___aries
fissionable	16	5	333	4	fissionable_
imaginaries	14	5	372	4	imagi_naries
lectionaries	14	5	477	4	lectionaries
legionaries	12	7	456	4	_legionaries
masonries	11	4	685	4	m_as_on_ries
midstories	13	4	565	4	midsto__ries
militaries	12	4	944	4	mi_li_taries
millenaries	13	5	552	4	mi_llenaries
milliaries	12	4	824	4	milli__aries
millineries	13	5	548	4	milli_neries
millionaire	13	7	292	4	millionaire_
millionairess	15	8	170	4	millionairess
misandries	13	4	506	4	mi_s_andries
misentries	12	4	782	4	mi_s_entries
misogamies	15	4	526	4	mi_s_ogamies
missional	11	4	606	4	missiona___l
missioned	12	4	860	4	mission___ed
missioner	11	4	788	4	mission___er
missioning	13	4	740	4	mission__ing
missionize	21	18	441	4	mission__ize
missionized	23	12	322	4	mission_ized
missionizer	22	12	278	4	mission_izer
missionizers	23	10	205	4	missionizers
missionizing	24	5	319	4	missionizing
missions	10	3	1190	4	mission____s
questionaries	22	6	231	4	questionaries
visionariness	16	6	181	4	vi_sionariness
zillionaires	21	8	200	4	zillionaires

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	124790	0.390	458182.1
2	DLD Change Limit	124790	45	7.436	16781.9
3	Display Results	45	45	0.030	1500.0
	(SQL Overall)	178691	45	7.856	22745.8