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

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

187 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
petrologist1471188(None) 
metrologist14511231metrologist
petrologists1559141petrologists
cetologist13412252cet_ologist
ethologist14411892_ethologist
fetologist14410402fet_ologist
metrologists1588832metrologists
necrologist14410132necrologist
neurologist1249982neurologist
pathologist17410662pathologist
pedologist14410862pe_dologist
penologist13412842pe_nologist
petrologic1547732petrologi_c
petrologies1449892petrologies
prologist12315082p__rologist
serologist11413152se_rologist
anthologist15410463anthologist
cetologists1449163cet_ologists
cytologist16410533cyt_ologist
dendrologist1555093dendrologist
ecologist12314143_e_cologist
electrologist1657053electrologist
enologist10314123_e_nologist
ethnologist1549263_ethnologist
ethologists1549023_ethologists
etymologist17158023_etymologist
fetologists1547993fet_ologists
futurologist1673503futurologist
gemmologist1746543gemmologist
gemologist141010283ge_mologist
geologist11611783ge__ologist
horologist14412363_horologist
hydrologist1948333hydrologist
meteorologist1654873meteorologist
metrologies1449583metrologies
mythologist2059003mythologist
necrologists1547873necrologists
neologist10712813ne__ologist
nephrologist1856303nephrologist
neurologists1347643neurologists
ontologist11411363ont_ologist
orologist10313103__orologist
osteologist1248563osteologist
otologist10412813_ot_ologist
papyrologist2055093papyrologist
pathologists1848373pathologists
pedologists1548273pe_dologists
penologists1449593pe_nologists
petrological1758593petrological
petrology1547333petrolog__y
philologist1768433philologist
phonologist17411563phonologist
phycologist2259183phycologist
pomologist15412043p_omologist
prologists13311173p__rologists
psephologist2056603psephologist
pteridologist17144603pteridologist
semiologist14410713semiologist
serologists12410123se_rologists
sexologist1849513se_xologist
speleologist1555743speleologist
teleologist1249383teleologist
urologist10411053__urologist
virologist1448813_virologist
aerologic1249604ae_rologi_c
aerologies11312024ae_rologies
aeronomist1247744ae_ronomist
aetiologies1248984aetiologies
algologist1248244_algologist
anthologists1648034anthologists
apologist12412404__apologist
astrologies1247924astrologies
audiologist1347244audiologist
biologist12412344__biologist
bryologist1647384_bryologist
cetologies13410854cet_ologies
cosmologist1648374cosmologist
cytologists1748014cyt_ologists
demonologist1657054demonologist
dendrologists1654084dendrologists
deontologist1457414deontologist
ecologists13310924_e_cologists
electrologists1765654electrologists
embryologist2053884embryologist
enologists11310624_e_nologists
entomologist1556974entomologist
ethnologists1647044_ethnologists
ethologies14310544_ethologies
etiologic1246784_etiologi_c
etiologies1139414_etiologies
etymologise17185254_etymologise
etymologists18156494_etymologists
eulogist949044_e__ulogist
fetologies1439184fet_ologies
futurologists1773074futurologists
gemmologists1845234gemmologists
gemologists1577884ge_mologists
genealogist1354144genealogist
geologists1279164ge__ologists
hematologist18219204hematologist
herpetologist1984794herpet_ologist
histologist1547984histologist
horologists1548964_horologists
hydrologists2046094hydrologists
ideologist1248534_ideologist
iridologist1345794iridologist
lexicologist2294914lexicologist
limnologist1446684limnologist
martyrologist1953324martyrologist
meteorologists1754184meteorologists
methodologist2054314methodologist
metrological1748374metrological
metrology1546804metrolog__y
metropolis1456464metropolis_
mixologist2047694_mixologist
monologist13413614_monologist
museologist1445804museologist
mycologist18410354_mycologist
myologist15411094__myologist
mythologists2146894mythologists
necrologies1447994necrologies
nematologist15208474nematologist
neologism1247484ne__ologism
neologists1139774ne__ologists
nephrologists1954984nephrologists
neurologic1346804neurologi_c
neurologies1248244neurologies
numerologist1574914numerologist
oceanologist1555684oceanologist
ologist8313834____ologist
oncologist13410414_oncologist
ontologists1248904ont_ologists
oologist9313494___oologist
orologists1149824__orologists
osteologists1346764osteologists
otologists1149634_ot_ologists
palynologist1856304palynologist
papyrologists2154084papyrologists
paralogism1545664p_aralogism
pathologic1847434pathologi_c
pathologies1748734pathologies
pedologic1546974pe_dologi_c
pedologies1439344pe_dologies
penologies13311234pe_nologies
petroleums1452804petroleums_
petrolic1249694petrol__i_c
petrols92913084petrol___s_
philologists1876684philologists
phonologists1848774phonologists
phrenologist1857914phrenologist
phycologists2367134phycologists
physiologist21157324physiologist
piccoloist1654044piccolo_ist
planetologist1664504planet_ologist
poloist91016324p___olo_ist
pomologists1648984p_omologists
proctologist1758964proctologist
prologing1338954p__rologing
prologize2147964p__rologize
prologs103512134p__rolog_s_
prosodist1248914p__rosodist
psephologists2155294psephologists
psychologist23109114psychologist
pteridologists18133724pteridologists
pyrologies16310014p_yrologies
radiologist1399504radiologist
rheologist1449534_rheologist
seismologist15125274seismologist
selenologist1357004selenologist
semiologists1548224semiologists
serologic1248674se_rologi_c
serologies11311334se_rologies
sexologists1947254se_xologists
sinologist11510664_sinologist
sociologist1449884sociologist
speleologists1654324speleologists
technologist18137404technologist
teleologists1347224teleologists
teratologist13108574teratologist
tetralogies1245084tetralogies
topologist13410644_topologist
tribologist1447724tribologist
typologist1648894_typologist
ufologist1347054__ufologist
urologists1148414__urologists
virologists1546634_virologists
zoologist1949694__zoologist

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 Filter1786911488190.436409841.7
2DLD Change Limit1488191879.18616200.6
3Display Results1871870.1101700.0
 (SQL Overall)1786911879.73218361.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.