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

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

64 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
missioner	11	4	788	(None)
missioned	12	4	860	1	missioned
missioners	12	4	585	1	missioners
fissioned	13	4	552	2	fissioned
missileer	11	4	558	2	missileer
mission	9	3	1274	2	mission__
missional	11	4	606	2	missional
missionary	15	5	366	2	missionary
missionizer	22	12	278	2	missionizer
missions	10	3	1190	2	mission_s
assigner	9	4	485	3	_assigner
commissioner	18	5	307	3	~~com~~missioner
emission	10	4	767	3	emission__
emissions	11	4	692	3	emission_s
fashioner	15	11	432	3	fashioner
fission	10	3	873	3	fission__
fissional	12	4	512	3	fissional
fissions	11	3	803	3	fission_s
hissier	10	34	1050	3	hissi__er
massier	9	36	1522	3	massi__er
mentioner	11	4	669	3	mentioner
messier	9	34	1292	3	messi__er
milliner	10	28	1186	3	milli_ner
misatone	10	4	976	3	misatone_
misatoned	12	4	669	3	misatoned
misatones	11	4	893	3	misatones
miscoined	14	4	844	3	miscoined
misdoer	10	4	863	3	mi_sdo_er
misdone	10	3	1086	3	mi_sdone_
misinfer	13	4	532	3	mi_sinfer
misinter	10	3	883	3	mi_sinter
misjoinder	20	5	270	3	misjoinder
misjoined	19	4	545	3	misjoined
misliker	14	31	957	3	misli_ker
misnomer	12	4	714	3	mi_snomer
misquoter	20	4	338	3	misquoter
misshaper	16	4	440	3	misshaper
missies	9	34	2398	3	missi__es
missile	9	28	1540	3	missi_le_
missileers	12	4	419	3	missileers
missilery	14	4	455	3	missi_lery
missiles	10	30	1508	3	missi_les
missing	10	36	1907	3	missi_n_g
missioning	13	4	740	3	missioning
missionize	21	18	441	3	missionize
missionized	23	12	322	3	missionized
missionizers	23	10	205	3	missionizers
missionizes	22	12	379	3	missionizes
missises	10	35	1369	3	missi_ses
missive	12	24	1314	3	missi_ve_
missives	13	32	1284	3	missi_ves
misspoke	16	4	541	3	misspoke_
misspoken	17	4	326	3	misspoken
missteer	10	3	722	3	miss_teer
mistier	9	34	1871	3	misti__er
mossier	9	44	1381	3	mossi__er
motioner	10	3	759	3	m_otioner
mussier	9	33	1436	3	mussi__er
omission	10	4	653	3	omission__
omissions	11	4	615	3	omission_s
pensioner	11	4	666	3	pensioner
sissier	7	37	1136	3	sissi__er
tensioner	9	4	591	3	tensioner
visioned	12	4	701	3	vi_sioned

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.423	422437.4
2	DLD Change Limit	148641	64	6.580	22589.8
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	7.033	25407.5