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 “geologist” 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.

108 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
geologist1161178(None) 
gemologist141010281gemologist
geologists1279161geologists
neologist10712811neologist
apologist12412402apologist
biologist12412342biologist
cetologist13412252cetologist
ecologist12314142ecologist
enologist10314122enologist
eulogist949042_eulogist
fetologist14410402fetologist
gemmologist1746542gemmologist
gemologists1577882gemologists
geologic1247792geologi_c
geologies11410642geologies
geologize2046362geologize
ideologist1248532ideologist
myologist15411092myologist
neologism1247482neologism
neologists1139772neologists
ologist8313832__ologist
oologist9313492_oologist
orologist10313102orologist
otologist10412812otologist
pedologist14410862pedologist
penologist13412842penologist
prologist12315082prologist
rheologist1449532rheologist
serologist11413152serologist
sexologist1849512sexologist
ufologist1347052ufologist
urologist10411052urologist
zoologist1949692zoologist
algologist1248243algologist
analogist10410233analogist
angelologist1454163angelologist
apologise1248303apologise
apologists1348883apologists
biologism1447233biologism
biologists1349433biologists
bryologist1647383bryologist
cetologists1449163cetologists
colonist102617933_colonist
colorist102818993_colorist
cytologist16410533cytologist
dialogist1148273dialogist
ecologists13310923ecologists
elegist81311973_e_legist
enologists11310623enologists
ethologist14411893ethologist
eulogise945643_eulogise
eulogists1046653_eulogists
fetologists1547993fetologists
gemmologists1845233gemmologists
gemologies1449003gemologies
genealogist1354143genealogist
geodesist1183823geodesist
geologer1044483geolog_er
geologers1143623geologers
geological1448073geological
geologized2245413geologized
geologizes2146793geologizes
geology12257323geolog__y
gynecologist1954573gynecologist
horologist14412363horologist
ideologists1346653ideologists
melodist1149743me_lodist
metrologist14511233metrologist
mixologist2047693mixologist
monologist13413613monologist
museologist1445803museologist
mycologist18410353mycologist
myologists1648203myologists
necrologist14410123necrologist
neologic1149233neologi_c
neologies10411713neologies
neologisms1345483neologisms
neologistic1444373neologistic
neologize1946963neologize
neurologist1249983neurologist
ologists939443__ologists
oncologist13410413oncologist
ontologist11411363ontologist
oologists1039853_oologists
orologists1149823orologists
osteologist1248563osteologist
otologists1149633otologists
pedologists1548273pedologists
penologists1449593penologists
petrologist14711883petrologist
poloist91016323_polo_ist
pomologist15412043pomologist
prologists13311173prologists
rheologists1547313rheologists
semiologist14410713semiologist
serologists12410123serologists
sexologists1947253sexologists
sinologist11510663sinologist
soloist7915893_solo_ist
syllogist13167143syllogist
teleologist1249383teleologist
theologise14117743theologise
topologist13410643topologist
typologist1648893typologist
ufologists1445423ufologists
urologists1148413urologists
virologist1448813virologist
zoologists2047173zoologists

Search took 8 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 Filter1786911486410.420425454.8
2DLD Change Limit1486411087.50019818.8
3Display Results1081080.0631714.3
 (SQL Overall)1786911087.98322383.9
 
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.