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

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

70 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
mammalogies	15	5	246	(None)
mammalities	14	4	485	2	mammalities
mammalogist	15	5	306	2	mammalogist
mammalogists	16	5	216	2	mammalogists
analogies	10	19	1064	3	_a_nalogies
gemmologies	17	4	524	3	gemmologies
magalogues	14	5	281	3	ma_galogues
mammalogy	16	5	217	3	mammalog__y
aerologies	11	3	1202	4	_aerologies
agrologies	12	3	769	4	_agrologies
algologies	12	4	679	4	_algologies
anagogies	11	15	616	4	_a_nagogies
analogizes	20	13	603	4	_a_nalogizes
analogues	10	12	618	4	_a_nalogues
anemologies	14	4	692	4	anemologies
antilogies	11	4	1031	4	_antilogies
apiologies	13	3	906	4	_apiologies
apologies	12	3	1119	4	_a_pologies
areologies	11	3	982	4	_areologies
axiologies	18	3	748	4	_axiologies
campanologies	20	5	246	4	campanologies
carpologies	16	4	640	4	carpologies
catalogues	13	6	434	4	ca_talogues
cosmologies	16	4	670	4	cosmologies
demagogies	15	9	367	4	_demagogies
etymologies	17	17	680	4	etymologies
garbologies	15	4	488	4	garbologies
gemologies	14	4	900	4	_gemologies
genealogies	13	5	357	4	genealogies
hagiologies	16	4	534	4	hagiologies
haplologies	17	4	476	4	haplologies
homologies	16	3	1152	4	_homologies
hymnologies	20	4	610	4	hymnologies
idealogies	12	4	419	4	_idealogies
karyologies	19	4	444	4	karyologies
limnologies	14	4	553	4	limnologies
macaronies	14	4	617	4	ma_caronies
magalogs	12	4	525	4	ma_galog__s
magalogue	13	5	280	4	ma_galogue_
malacologies	17	5	438	4	malacologies
mamaligas	14	4	338	4	ma_malig_as
mammalian	12	4	371	4	mammal__ian
mammalians	13	5	248	4	mammal_ians
mammality	15	4	428	4	mammal__ity
mammals	10	38	927	4	mammal____s
mammies	10	43	1476	4	mamm____ies
mandatories	14	5	497	4	mandatories
marmalades	15	4	356	4	marmal_ades
menologies	13	3	1060	4	m_enologies
metrologies	14	4	958	4	metrologies
mineralogies	15	10	298	4	mineralogies
misologies	13	13	906	4	m_isologies
mixologies	20	13	658	4	m_ixologies
monologies	13	3	1254	4	m_onologies
museologies	14	4	454	4	museologies
mycologies	18	4	886	4	m_ycologies
myologies	15	3	975	4	__myologies
mystagogies	18	7	163	4	mystagogies
mythologies	20	4	784	4	mythologies
nomologies	13	3	947	4	_nomologies
paleologies	14	4	858	4	paleologies
pathologies	17	4	873	4	pathologies
pomologies	15	3	1004	4	_pomologies
radiologies	13	4	780	4	radiologies
sarcologies	14	4	643	4	sarcologies
semiologies	14	4	880	4	semiologies
symbologies	19	4	517	4	symbologies
tautologies	12	4	591	4	tautologies
tetralogies	12	4	508	4	tetralogies
zymologies	25	4	641	4	_zymologies

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.436	409841.7
2	DLD Change Limit	148819	70	8.326	17874.0
3	Display Results	70	70	0.033	2121.2
	(SQL Overall)	178691	70	8.795	20317.3