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

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

73 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
missileries	13	5	355	(None)
missilries	12	4	409	1	missil_ries
distilleries	13	5	283	3	distilleries
fissilities	14	4	564	3	fissilities
midwiferies	20	5	147	3	midwiferies
millineries	13	5	548	3	millineries
miniseries	12	4	675	3	mi_niseries
miseries	10	3	2040	3	mi_s__eries
missileer	11	4	558	3	missile__er
missileers	12	4	419	3	missile_ers
missilemen	14	5	319	3	missile_men
missilery	14	4	455	3	missiler__y
missiles	10	30	1508	3	missil___es
missiologies	15	5	331	3	missiologies
missionaries	14	5	362	3	missionaries
cassimeres	14	4	359	4	cassimer_es
cassiterites	14	5	234	4	cassiterites
diableries	13	4	460	4	di_ableries
discoveries	17	4	580	4	discoveries
disserves	13	8	806	4	diss__erves
dissidences	15	16	413	4	dissidences
emissaries	12	4	477	4	emiss__aries
emissivities	17	5	295	4	emissivities
fisheries	15	4	864	4	fi_s_heries
gossipries	13	5	243	4	gossi_pries
hosieries	12	4	921	4	_hosi_eries
machineries	18	5	379	4	machineries
massinesses	12	12	869	4	massinesses
masteries	11	10	1849	4	m_as_teries
mesenteries	13	4	589	4	mesenteries
messinesses	12	9	751	4	messinesses
midstories	13	4	565	4	mids_tories
militaries	12	4	944	4	mi_litaries
millerites	12	4	793	4	mi__llerites
milliaries	12	4	824	4	milli_aries
millicuries	15	5	370	4	millicuries
millihenries	17	5	207	4	millihenries
mimicries	15	4	476	4	mi_mi_cries
ministries	12	4	756	4	mi_nistries
misallies	11	4	838	4	mi_sal_lies
misandries	13	4	506	4	mi_sandries
miscarries	14	4	544	4	mi_scarries
misentries	12	4	782	4	mi_sentries
misereres	11	4	818	4	mi_serer_es
misfiles	13	31	1098	4	misfil___es
misfires	13	22	1058	4	misfi__r_es
mislies	9	29	2228	4	mi_s_l__ies
mislikers	15	31	706	4	misliker__s
misologies	13	13	906	4	mi_sologies
misrelies	11	4	972	4	mi_s_relies
missenses	11	4	803	4	miss__enses
missies	9	34	2398	4	miss____ies
missile	9	28	1540	4	missil___e_
missileman	14	5	173	4	missile_man
missilry	13	4	465	4	missil_r__y
missioners	12	4	585	4	missioner__s
missionizes	22	12	379	4	missionizes
missises	10	35	1369	4	missi___ses
missives	13	32	1284	4	missi___ves
missteered	13	4	355	4	missteer_ed
missteering	14	4	445	4	missteering
missteers	11	3	591	4	missteer__s
misstrikes	16	4	436	4	miss__trikes
mistinesses	13	13	1062	4	mistinesses
mistletoes	12	4	351	4	mi_stletoes
mossinesses	12	11	746	4	mossinesses
mussinesses	12	14	744	4	mussinesses
mysteries	14	12	1119	4	m_ys_teries
rifleries	12	4	768	4	ri__fleries
sealeries	9	3	1313	4	__sealeries
sessilities	11	4	640	4	sessilities
sissinesses	9	11	831	4	sissinesses
spiceries	13	4	931	4	__spiceries

Search took 9 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	73	7.826	19016.0
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	8.279	21583.6