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

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

72 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
oceanologists	16	5	430	(None)
oceanologist	15	5	568	1	oceanologist_
oceanologies	15	5	422	2	oceanologi_es
cetologists	14	4	916	3	_ce_tologists
enologists	11	3	1062	3	__e_nologists
penologists	14	4	959	3	_pe_nologists
technologists	19	12	570	3	technologists
urbanologists	16	5	325	3	urbanologists
volcanologists	20	12	276	3	volcanologists
analogists	11	4	731	4	___analogists
apologists	13	4	888	4	___apologists
archaeologists	20	12	280	4	archaeologists
campanologists	21	5	262	4	campanologists
cetologist	13	4	1225	4	_ce_tologist_
chronologists	19	6	611	4	chronologists
conchologists	21	5	456	4	conchologists
cosmologists	17	4	641	4	_cosmologists
cytologists	17	4	801	4	_c_ytologists
demonologists	17	5	556	4	demonologists
deontologists	15	5	592	4	_deontologists
ecologists	13	3	1092	4	__e_cologists
enologist	10	3	1412	4	__e_nologist_
escapologists	18	5	334	4	escapologists
ethnologists	16	4	703	4	_ethnologists
ethologists	15	4	901	4	__ethologists
fetologists	15	4	799	4	_fe_tologists
gemmologists	18	4	523	4	_gemmologists
gemologists	15	7	788	4	_ge_mologists
geologists	12	7	916	4	_ge__ologists
hematologists	19	21	704	4	hematologists
ideologists	13	4	665	4	ide__ologists
immunologists	18	12	449	4	immunologists
lichenologists	20	6	302	4	lichenologists
limnologists	15	4	532	4	_limnologists
malacologists	18	5	440	4	malacologists
metrologists	15	8	882	4	_metrologists
monologists	14	4	1007	4	__monologists
necrologists	15	4	787	4	_necrologists
nematologists	16	16	659	4	nematologists
neologists	11	3	977	4	_ne__ologists
neurologists	13	4	764	4	_neurologists
oceanology	16	4	355	4	oceanolog___y
oenologies	11	3	939	4	o_e_nologi_es
oncologists	14	4	807	4	o__ncologists
onomatologists	17	5	332	4	onomatologists
ontologists	12	4	890	4	o__ntologists
oologists	10	3	985	4	o____ologists
organologies	14	5	407	4	organologi_es
orologists	11	4	982	4	o___rologists
osteologists	13	4	676	4	o_steologists
otologists	11	4	963	4	o___tologists
palynologists	19	5	499	4	palynologists
pedologists	15	4	827	4	_pe_dologists
penologist	13	4	1284	4	_pe_nologist_
petrologists	15	5	913	4	_petrologists
phonologists	18	4	877	4	_phonologists
phrenologists	19	5	629	4	phrenologists
psephologists	21	5	529	4	psephologists
rheologists	15	4	731	4	rhe__ologists
selenologists	14	5	533	4	selenologists
semiologists	15	4	822	4	_semiologists
serologists	12	4	1012	4	_se_rologists
sexologists	19	4	725	4	_se_xologists
sinologists	12	5	767	4	__sinologists
sociologists	15	4	794	4	soc__iologists
speleologists	16	5	432	4	speleologists
technologist	18	13	740	4	technologist_
teleologists	13	4	722	4	_teleologists
teratologists	14	9	658	4	teratologists
urbanologist	15	5	404	4	urbanologist_
volcanologist	19	9	316	4	volcanologist_
vulcanologists	20	9	230	4	vulcanologists

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.110	1624463.6
2	DLD Change Limit	95024	72	5.703	16662.1
3	Display Results	72	72	0.046	1565.2
	(SQL Overall)	178691	72	5.859	30498.5