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

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

51 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
genealogical	16	5	271	(None)
genealogically	21	6	312	2	genealogically
analogical	13	5	636	3	_an_alogical
enological	13	4	888	3	_en_ological
gemological	17	4	702	3	ge_mological
genealogies	13	5	357	3	genealogi_es
genealogist	13	5	414	3	genealogi_st
genealogists	14	5	278	3	genealogists
geological	14	4	807	3	g__eological
gynecological	22	11	378	3	gynecological
mineralogical	18	6	228	3	mineralogical
penological	16	4	887	3	pen_ological
teleological	15	4	657	3	teleological
alogical	11	4	776	4	____alogical
anagogical	14	9	410	4	_an_agogical
antilogical	14	4	727	4	_antilogical
dendrological	18	5	383	4	dendrological
deontological	17	5	517	4	deontological
dialogical	14	4	551	4	__dialogical
ecological	15	4	870	4	_e_cological
ethological	17	4	819	4	_ethological
etiological	14	4	841	4	_etiological
extralogical	22	9	413	4	extralogical
genealogy	14	4	271	4	genealog___y
generical	12	4	700	4	gene___rical
genetical	12	4	758	4	gene___tical
gerontological	18	5	417	4	gerontological
ideological	15	10	664	4	_ideological
metrological	17	4	837	4	metrological
museological	17	5	478	4	museological
necrological	17	4	728	4	necrological
neurological	15	4	733	4	neurological
nonlogical	13	4	706	4	__nonlogical
oncological	16	4	725	4	_oncological
ontological	14	4	831	4	_ontological
osteological	15	4	637	4	osteological
pedagogical	18	5	227	4	pe_dagogical
pedological	17	5	761	4	pe_dological
petrological	17	5	859	4	petrological
phenological	20	6	805	4	phen_ological
prelogical	15	4	669	4	_pre_logical
rheological	17	12	747	4	_rheological
selenological	16	5	466	4	selenological
semiological	17	4	778	4	semiological
serological	14	6	877	4	se_rological
sinological	14	4	713	4	sin_ological
speleological	18	5	391	4	speleological
stereological	16	5	567	4	stereological
synecological	21	10	411	4	synecological
theological	17	9	826	4	_theological
unecological	17	4	582	4	unecological

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	124790	0.390	458182.1
2	DLD Change Limit	124790	51	7.500	16638.7
3	Display Results	51	51	0.033	1545.5
	(SQL Overall)	178691	51	7.923	22553.5