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

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

58 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
gerontologies	15	8	443	(None)
deontologies	14	4	541	2	de_ontologies
gerontologic	16	5	376	2	gerontologi_c
gerontologist	15	5	599	2	gerontologist
gerontologists	16	5	485	2	gerontologists
aerobiologies	16	5	505	3	aerobiologies
chronologies	18	4	641	3	chron_ologies
demonologies	16	4	550	3	demon_ologies
dermatologies	17	5	525	3	dermatologies
gerontological	18	5	417	3	gerontological
gerontology	16	5	336	3	gerontolog__y
herpetologies	19	5	346	3	herpetologies
neonatologies	14	5	382	3	ne_onatologies
ontologies	11	3	988	3	___ontologies
proctologies	17	4	631	3	_proctologies
teratologies	13	4	687	3	ter_atologies
aerologies	11	3	1202	4	aer___ologies
cetologies	13	4	1085	4	ce___tologies
craniologies	15	4	537	4	_craniologies
cryptologies	20	5	542	4	_cryptologies
deontologist	14	5	741	4	de_ontologist
deontologists	15	5	592	4	de_ontologists
enologies	10	3	1298	4	_e__n_ologies
ethnologies	15	4	798	4	_ethn_ologies
exobiologies	22	5	440	4	_exobiologies
fetologies	14	3	918	4	fe___tologies
garbologies	15	4	488	4	gar__bologies
gemmologies	17	4	524	4	ge__mmologies
gemologies	14	4	900	4	ge___mologies
genealogies	13	5	357	4	ge__nealogies
geochronologies	22	6	199	4	ge~~och~~ron_ologies
geologies	11	4	1064	4	ge____ologies
gerontocracies	19	7	141	4	gerontocracies
graphologies	19	6	373	4	g_raphologies
hematologies	18	4	756	4	he_matologies
herbologies	17	4	656	4	her__bologies
iconologies	14	4	709	4	_icon_ologies
laryngologies	18	12	214	4	laryngologies
menologies	13	3	1060	4	me__n_ologies
monologies	13	3	1254	4	__mon_ologies
narratologies	14	5	275	4	narratologies
nematologies	15	4	669	4	ne_matologies
neurobiologies	17	6	391	4	neurobiologies
nostologies	12	4	658	4	__nostologies
oenologies	11	3	939	4	oe__n_ologies
oncologies	13	4	865	4	___oncologies
otologies	10	3	1140	4	___o_tologies
paleontologies	17	10	388	4	paleontologies
penologies	13	3	1123	4	pe__n_ologies
phonologies	17	4	1000	4	_phon_ologies
phrenologies	18	4	631	4	phren_ologies
selenologies	13	4	528	4	selen_ologies
serologies	11	3	1133	4	ser___ologies
technologies	18	4	597	4	techn_ologies
terminologies	16	5	344	4	terminologies
tropologies	14	4	773	4	_tro_pologies
uranologies	12	4	613	4	_uran_ologies
venologies	14	3	837	4	ve__n_ologies

Search took 6 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	95024	0.360	496363.9
2	DLD Change Limit	95024	58	5.500	17277.1
3	Display Results	58	58	0.046	1260.9
	(SQL Overall)	178691	58	5.906	30255.8