Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

185 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
ologist831383(None) 
ologists939441ologists
oologist9313491oologist
apologist12412402apologist
biologist12412342biologist
colonist102617932colonist
colorist102818992colorist
ecologist12314142ecologist
elegist81311972elegist
enologist10314122enologist
eulogist949042eulogist
florist10314242florist
geologist11611782geologist
legist71315252_legist
logiest82515542_logiest
lookist1139562lookist
myologist15411092myologist
neologist10712812neologist
oboist8312682obo_ist
ologies8615022ologies
oologists1039852oologists
orologist10313102orologist
otologist10412812otologist
poloist91016322polo_ist
prologist12315082prologist
soloist7915892solo_ist
ufologist1347052ufologist
urologist10411052urologist
zoologist1949692zoologist
agist66325583__agist
agonist82615403agonist
algologist1248243algologist
alist56136783al__ist
altoist7313393altoist
amorist9317643amorist
analogist10410233analogist
aorist64827873_aorist
apologise1248303apologise
apologists1348883apologists
atomist92915763atomist
biologism1447233biologism
biologists1349433biologists
blogs85319233blog_s_
blowiest1337923blowiest
bongoist1147643bongoist
bryologist1647383bryologist
cetologist13412253cetologist
cladist10311973cladist
cloggiest1334723cloggiest
clogs85519553clog_s_
clonism1138983clonism
closest94312533closest
collagist1248023collagist
cologs96517363colog_s_
colonise102514283colonise
colonists112512503colonists
colorism122112433colorism
colorists112313593colorists
cytologist16410533cytologist
dialogist1148273dialogist
ecologists13310923ecologists
egoist7612283ego_ist
egotist8411273egotist
elegise8139393elegise
elegists9128113elegists
elegit71212893elegi_t
elegits8149343elegits
elitist7414913elitist
enologists11310623enologists
ethologist14411893ethologist
eulogise945643eulogise
eulogists1046653eulogists
fetologist14410403fetologist
flogs95919963flog_s_
florists1138813florists
flutist102910783flutist
foist85730973_fo_ist
gemologist141010283gemologist
geologists1279163geologists
gist56046773___gist
gloggs935033gloggs_
glost65422933glo__st
gnomist1049133gnomist
hoist86433213_ho_ist
holist94723213_holist
horologist14412363horologist
ideologist1248533ideologist
imagist1077333imagist
ironist7314843ironist
joist125125653_jo_ist
legists899593_legists
legit61323503_legi_t
legits71313003_legits
list47055353_l__ist
locust85312343_locust
loges66534203_loges_
loggiest103011013loggiest
loggish12258733loggish
logia68116603_logi_a
logic88217833_logi_c
logics95711123_logics
logier75015733_logier
logily1039833_logily
login66025003_logi_n
logins77820643_logins
logion76013723_logion
logistic1147823_logistic
logos67225333_logos_
logs57343113_log_s_
longest84114953longest
longish11229093longish
lookism1335913lookism
lookists1245713lookists
looniest83313253looniest
loopiest103011323loopiest
loosest75811563loosest
loris55329153_loris_
lost47951493_lo__st
louis57322323_louis_
lowest93915593_lowest
lowish12310533_lowish
lutist64317553_lutist
lyrist9312293_lyrist
melodist1149743melodist
mixologist2047693mixologist
moist76033583_mo_ist
monist84324983_monist
monodist11310923monodist
monologist13413613monologist
motorist10314413motorist
mycologist18410353mycologist
myologists1648203myologists
neologism1247483neologism
neologists1139773neologists
oboists937903obo_ists
oculist9310883oculist
odist6421913__odist
oldest72114093ol_dest
oldish10169313ol_dish
ology94113113olog__y
oloroso744613oloroso
onanist7314633onanist
oncologist13410413oncologist
ontologist11411363ontologist
oocyst1136133o_ocyst
oologic1049423oologi_c
oologies9312993oologies
ooziest163411523o_oziest
oralist7619633oralist
orgiast837463o_rgiast
orologists1149823orologists
otocyst1244833otocyst
otologists1149633otologists
ozonise1646443ozonise
pedologist14410863pedologist
penologist13412843penologist
plenist9314333plenist
polemist12412363polemist
pollist9816603pol_list
poloists10910523polo_ists
pomologist15412043pomologist
prologists13311173prologists
protist9320223protist
rheologist1449533rheologist
serologist11413153serologist
sexologist1849513sexologist
shogis103810943shogis_
sinologist11510663sinologist
slogs64521843slog_s_
slowest10168713slowest
slowish1337633slowish
sodomist1157633sodomist
solecist10910783solecist
soloists869153solo_ists
syllogist13167143syllogist
topologist13410643topologist
typologist1648893typologist
ufologists1445423ufologists
urologists1148413urologists
utopist938693utopist
violist10312143violist
virologist1448813virologist
volost9412643volo__st
yogis95617743_yogis_
zoologists2047173zoologists

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.406440125.6
2DLD Change Limit1340271856.20321606.8
3Display Results1851850.0762434.2
 (SQL Overall)1786911856.68526730.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.