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

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

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.

77 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
gemologists	15	7	788	(None)
gemmologists	18	4	523	1	gemmologists
gemologist	14	10	1028	1	gemologist_
geologists	12	7	916	1	ge_ologists
cetologists	14	4	916	2	cetologists
ecologists	13	3	1092	2	_ecologists
enologists	11	3	1062	2	_enologists
fetologists	15	4	799	2	fetologists
gemmologist	17	4	654	2	gemmologist_
gemologies	14	4	900	2	gemologi_es
geologist	11	6	1178	2	ge_ologist_
neologists	11	3	977	2	ne_ologists
pedologists	15	4	827	2	pedologists
penologists	14	4	959	2	penologists
pomologists	16	4	898	2	pomologists
semiologists	15	4	822	2	semiologists
serologists	12	4	1012	2	serologists
sexologists	19	4	725	2	sexologists
algologists	13	4	614	3	algologists
angelologists	15	5	337	3	angelologists
apologists	13	4	888	3	_apologists
biologists	13	4	943	3	_biologists
bryologists	17	4	570	3	bryologists
cetologist	13	4	1225	3	cetologist_
cosmologists	17	4	641	3	cosmologists
cytologists	17	4	801	3	cytologists
demonologists	17	5	556	3	demonologists
ecologist	12	3	1414	3	_ecologist_
enologist	10	3	1412	3	_enologist_
ethologists	15	4	902	3	ethologists
etymologists	18	15	649	3	etymologists
eulogists	10	4	665	3	_e_ulogists
fetologist	14	4	1040	3	fetologist_
gemmologies	17	4	524	3	gemmologi_es
gemological	17	4	702	3	gemological
genealogists	14	5	278	3	genealogists
geologies	11	4	1064	3	ge_ologi_es
geologizes	21	4	679	3	ge_ologizes
gynecologists	20	5	369	3	gynecologists
hematologists	19	21	705	3	hematologists
horologists	15	4	896	3	horologists
ideologists	13	4	665	3	ideologists
limnologists	15	4	532	3	limnologists
metrologists	15	8	883	3	metrologists
mixologists	21	4	568	3	mixologists
monologists	14	4	1007	3	monologists
mycologists	19	4	773	3	mycologists
myologists	16	4	820	3	_myologists
necrologists	15	4	787	3	necrologists
nematologists	16	16	660	3	nematologists
neologisms	13	4	548	3	ne_ologisms
neologist	10	7	1281	3	ne_ologist_
neurologists	13	4	764	3	neurologists
ologists	9	3	944	3	___ologists
oncologists	14	4	807	3	oncologists
ontologists	12	4	890	3	ontologists
oologists	10	3	985	3	__oologists
orologists	11	4	982	3	_orologists
otologists	11	4	963	3	_otologists
pedologist	14	4	1086	3	pedologist_
penologist	13	4	1284	3	penologist_
petrologists	15	5	914	3	petrologists
pomologist	15	4	1204	3	pomologist_
prologists	13	3	1117	3	_prologists
rheologists	15	4	731	3	rheologists
seismologists	16	12	419	3	seismologists
semiologist	14	4	1071	3	semiologist_
serologist	11	4	1315	3	serologist_
sexologist	18	4	951	3	sexologist_
sinologists	12	5	767	3	sinologists
teleologists	13	4	722	3	teleologists
topologists	14	4	786	3	topologists
typologists	17	4	681	3	typologists
ufologists	14	4	542	3	_ufologists
urologists	11	4	841	3	_urologists
virologists	15	4	663	3	virologists
zoologists	20	4	717	3	_zoologists

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	121633	0.440	406115.9
2	DLD Change Limit	121633	77	5.530	21995.1
3	Display Results	77	77	0.046	1673.9
	(SQL Overall)	178691	77	6.016	29702.6