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

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

41 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
missilery	14	4	455	(None)
missilry	13	4	465	1	missil_ry
missile	9	28	1540	2	missile__
missileer	11	4	558	2	missileer
missileers	12	4	419	2	missileers
missiles	10	30	1508	2	missile_s
distillery	14	4	315	3	distillery
fissile	10	26	965	3	fissile__
fissility	15	4	461	3	fissility
hissier	10	34	1050	3	hissi_er_
massier	9	36	1522	3	massi_er_
massively	17	4	415	3	massively
messier	9	34	1292	3	messi_er_
messily	12	29	881	3	messil__y
midwifery	21	5	154	3	midwifery
millinery	14	33	610	3	millinery
misery	11	41	1354	3	mi_s__ery
misfile	12	26	1155	3	misfile__
misfiled	14	27	865	3	misfile_d
misfiles	13	31	1098	3	misfile_s
misliker	14	31	957	3	misliker_
mislikers	15	31	706	3	mislikers
missies	9	34	2398	3	missi_e_s
missileman	14	5	173	3	missileman
missilemen	14	5	319	3	missilemen
missileries	13	5	355	3	missileries
missiology	16	5	316	3	missiology
missionary	15	5	366	3	missionary
missioner	11	4	788	3	missioner_
missioners	12	4	585	3	missioners
missises	10	35	1369	3	missise_s
missive	12	24	1314	3	missive__
missives	13	32	1284	3	missive_s
missteer	10	3	722	3	missteer_
missteers	11	3	591	3	missteers
mistier	9	34	1871	3	misti_er_
mistily	12	26	1234	3	mistil__y
mossier	9	44	1381	3	mossi_er_
mussier	9	33	1436	3	mussi_er_
mussily	12	27	977	3	mussil__y
sissier	7	37	1136	3	sissi_er_

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.406	440125.6
2	DLD Change Limit	148641	41	7.063	21045.0
3	Display Results	41	41	0.016	2562.5
	(SQL Overall)	178691	41	7.485	23873.2