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

Here are the results of your fuzzy-string dictionary search for “geohydrologies” with Change Limit: [1] [2] [3] [4] [5] [6]

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.

50 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
geohydrologies	23	6	151	(None)
geohydrologic	24	6	145	2	geohydrologi_c
geohydrologist	23	7	185	2	geohydrologist
geohydrologists	24	6	152	2	geohydrologists
geohydrology	24	6	155	3	geohydrolog__y
hydrologies	19	4	818	3	___hydrologies
dendrologies	15	5	379	4	de__ndrologies
geochronologies	22	6	199	4	geochronologies
methodologies	20	5	348	4	method_ologies
nephrologies	18	4	507	4	neph__rologies
aerologies	11	3	1202	5	ae____rologies
andrologies	13	4	611	5	___andrologies
cohomologies	20	5	405	5	_coh_omologies
coprologies	16	4	694	5	_co__prologies
deontologies	14	4	541	5	deo__ntologies
ecophysiologies	26	7	130	5	ecophysiologies
electrologies	16	5	625	5	_electrologies
enzymologies	27	5	295	5	_enzy_mologies
ethnologies	15	4	798	5	_eth__nologies
ethologies	14	3	1054	5	_eth___ologies
etymologies	17	17	680	5	_e_ty_mologies
gemmologies	17	4	524	5	ge___mmologies
gemologies	14	4	900	5	ge____mologies
geologies	11	4	1064	5	ge_____ologies
geomorphologies	24	7	131	5	geomorphologies
gerontologies	15	8	443	5	ge_rontologies
hierologies	15	4	706	5	___hierologies
horologies	14	4	1105	5	___h_orologies
hydrologic	20	4	667	5	___hydrologi_c
hydrologist	19	4	833	5	___hydrologist
hydrologists	20	4	609	5	___hydrologists
hymnologies	20	4	610	5	___hymnologies
hypnologies	20	4	608	5	___hypnologies
martyrologies	19	5	233	5	marty_rologies
meteorologies	16	5	358	5	me_teorologies
metrologies	14	4	958	5	me___trologies
necrologies	14	4	798	5	ne___crologies
neonatologies	14	5	382	5	neo_natologies
nephologies	17	4	735	5	neph___ologies
neurologies	12	4	823	5	ne___urologies
orologies	10	3	1162	5	__o___rologies
papyrologies	20	7	360	5	_papy_rologies
pedologies	14	3	934	5	pe___d_ologies
petrologies	14	4	989	5	pe___trologies
phycologies	22	4	778	5	__phy_cologies
physiologies	21	5	536	5	__physiologies
phytologies	20	4	904	5	__phy_tologies
pyrologies	16	3	1001	5	___py_rologies
serologies	11	3	1133	5	se____rologies
technologies	18	4	597	5	tech__nologies

Search took 7 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.356	501941.0
2	DLD Change Limit	95024	50	6.360	14940.9
3	Display Results	50	50	0.046	1087.0
	(SQL Overall)	178691	50	6.762	26425.8