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 “musicologists” with Change Limit: [1] [2] [3] [4] [5]

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

202 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
musicologists185354(None) 
musicologist1754281musicologist_
museologists1544742mus_eologists
musicologies1753382musicologi_es
audiologists1445613audi_ologists
lexicologists2374153lexicologists
malacologists1854403malacologists
mixologists2145683m__ixologists
museologist1445803mus_eologist_
musicological2053543musicological
mycologists1947733m__ycologists
sinologists1257673__sinologists
toxicologists2353983toxicologists
audiologist1347244audi_ologist_
biologists1349434__bi_ologists
cosmologists1746414cos_mologists
ecologists13310924___ecologists
futurologists1773074futurologists
glaciologists1753944glaciologists
gynecologists2053694gynecologists
histologists1646294his_tologists
iridologists1444684_iridologists
lexicologist2294914lexicologist_
malacologist1755634malacologist_
metrologists1588834m_etrologists
mixologist2047694m__ixologist_
monologists14410074m__onologists
morphologists2154264morphologists
museologies1444544mus_eologi_es
musicalises1554014musical__ises
musicology1853254musicolog___y
mycologist18410354m__ycologist_
myologists1648204m___yologists
myrmecologists2452784myrmecologists
mythologists2146894m_ythologists
numerologists1664014numerologists
oncologists1448074__oncologists
osteologists1346764_osteologists
philologists1876684_philologists
phycologists2367134_phycologists
physiologists22156014physi_ologists
psychologists24127474_psychologists
radiologists1497364radi_ologists
seismologists16124194seismologists
semiologists1548224semi_ologists
serologists12410124__serologists
sexologists1947254__sexologists
sinologist11510664__sinologist_
sociologists1547944__sociologists
toxicologist2254834toxicologist_
tribologists1546164_tribologists
trichologists1955424_trichologists
ufologists1445424_u__fologists
urologists1148414_u__rologists
virologists1546634__virologists
algologists1346145__algologists
angelologists1553375angelologists
anthologists1648035_anthologists
apologists1348885___apologists
audiologies1345625audi_ologi_es
autecologies1554575autecologi_es
biologisms1545345__bi_ologisms
biologist12412345__bi_ologist_
bryologists1745705__bryologists
cardiologists1765145cardiologists
cetologists1449165__cetologists
chronologists1966115chronologists
codicologies1853665codicologi_es
colonists112512505____colonists
colorists112313595____colorists
conchologists2154565conchologists
cosmetologists1953145cosmetologists
cosmologist1648375cos_mologist_
criminologists1952975criminologists
cryptologists2155235cryptologists
cytologists1748015__cytologists
demonologists1755565demonologists
dendrologists1654085dendrologists
deontologists1555925deontologists
dialogists1265605__di_alogists
ecologist12314145___ecologist_
embryologists2153125embryologists
enologists11310625___enologists
entomologists1655665entomologists
enzymologists2873115enzymologists
escapologists1853345escapologists
ethnologists1647045_ethnologists
ethologists1549025__ethologists
etymologists18156495_etymologists
eulogists1046655eu____logists
exobiologists2355325exobiologists
fetologists1547995__fetologists
fusionists1354475fusi___onists
futurologist1673505futurologist_
gemmologists1845235_gemmologists
gemologists1577885__gemologists
geologists1279165___geologists
glaciologist1654895glaciologist_
graphologists20123835graphologists
gynecologist1954575gynecologist_
hematologists19217055hematologists
histologist1547985his_tologist_
horologists1548965__horologists
hydrologists2046095_hydrologists
ideologists1346655__ideologists
immunologists18124495immunologists
iridologist1345795_iridologist_
lexicologies2253635lexicologi_es
limnologists1545325_limnologists
malacologies1754385malacologi_es
malariologists1773355malariologists
mammalogists1652165m_ammalogists
martyrologists2062895martyrologists
masculinists16102625mas_culinists
meteorologists1754185meteorologists
methodologists2153475methodologists
metrologist14511225m_etrologist_
mineralogists1652315mineralogists
misologies13139065m__isologi_es
missiologies1553315missiologi_es
mixologies20136585m__ixologi_es
monologist13413615m__onologist_
monologuists1553955m__onologuists
morphologist2055505morphologist_
museological1754785mus_eological
musicalise1454615musical__is_e
musicalised1653095musical__ised
musicalities1655825musicaliti_es
musicality1745245musical__i_ty
musicalizes2454035musical__izes
musicless1343605music_l__es_s
mycologies1848865m__ycologi_es
myologist15411095m___yologist_
myrmecologist2353315myrmecologist_
mythologist2058995m_ythologist_
necrologists1547875_necrologists
nematologists16166605nematologists
neologists1139775___neologists
nephrologists1954985nephrologists
neurologists1347645_neurologists
nonbiologists1664725nonbiologists
numerologist1574915numerologist_
oceanologists1654305oceanologists
ologists939445_____ologists
oncologist13410415__oncologist_
ontologists1248905__ontologists
oologists1039855____oologists
ornithologists1852595ornithologists
orologists1149825___orologists
osteologist1248565_osteologist_
otologists1149635___otologists
palynologists1954995palynologists
papyrologists2154085papyrologists
parasitologists1862805parasitologists
pathologists1848375_pathologists
pedologists1548275__pedologists
penologists1449595__penologists
petrologists1559145_petrologists
philologist1768435_philologist_
phonologists1848775_phonologists
phrenologists1956295phrenologists
phycologist2259185_phycologist_
physiologist21157325physi_ologist_
piccoloists1752775_piccolo_ists
pomologists1648985__pomologists
proctologists1856815proctologists
prologists13311175___prologists
psephologists2155295psephologists
psychologises24136165_psychologises
psychologisms26124775_psychologisms
psychologist23109115_psychologist_
pteridologists18133725pteridologists
radiologist1399495radi_ologist_
rheologists1547315__rheologists
sciolists1147215__sciol__ists
seismologist15125275seismologist_
selenologists1455335selenologists
semiologist14410715semi_ologist_
serologist11413155__serologist_
sexologist1849515__sexologist_
sinologies1148895__sinologi_es
sitologies1148705__sitologi_es
sociologist1449885__sociologist_
soloists869155__s__olo_ists
speleologists1654325speleologists
syllogists14175175__s_yllogists
technologists19125705technologists
teleologists1347225_teleologists
teratologists1496595teratologists
topologists1447865__topologists
toxicologies2263755toxicologi_es
tribologist1447725_tribologist_
trichologist1856745_trichologist_
typologists1746815__typologists
ufologist1347055_u__fologist_
urbanologists1653255urbanologists
urologist10411055_u__rologist_
vexillologists2591745vexillologists
victimologists2262255victimologists
virologist1448815__virologist_
vulcanologists2092305vulcanologists
zoologists2047175___zoologists

Search took 10 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 Filter1786911247900.390458182.1
2DLD Change Limit1247902028.92313985.2
3Display Results2022020.1231642.3
 (SQL Overall)1786912029.43618937.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.