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

127 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
hydrologists204609(None) 
hydrologist1948331hydrologist_
horologists1548962h_orologists
hydrologies1948182hydrologi_es
audiologists1445613audiologists
cytologists1748013cy_tologists
dendrologists1654083dendrologists
geohydrologists2461523geohydrologists
histologists1646293histologists
horologist14412363h_orologist_
hydrobiologists25134043hydrobiologists
hydrologic2046673hydrologi__c
hydrological2246483hydrological
ideologists1346653_ideologists
metrologists1588833metrologists
mycologists1947733my_cologists
myologists1648203my__ologists
mythologists2146893mythologists
necrologists1547873necrologists
neurologists1347643neurologists
orologists1149823__orologists
pedologists1548273ped_ologists
petrologists1559143petrologists
phycologists2367133phy_cologists
physiologists22156013physiologists
prologists13311173__prologists
radiologists1497363radiologists
serologists12410123_serologists
typologists1746813ty_pologists
urologists1148413__urologists
virologists1546633_virologists
algologists1346144_algologists
andrologies1346114andrologi_es
anthologists1648034anthologists
apologists1348884__apologists
audiologist1347244audiologist_
biologists1349434__biologists
bryologists1745704_bryologists
cardiologists1765144cardiologists
cetologists1449164_cetologists
chronologists1966114chronologists
cosmologists1746414cosmologists
cryptologists2155234cryptologists
cytologist16410534cy_tologist_
dendrologist1555094dendrologist_
dialogists1265604__dialogists
ecologists13310924__ecologists
embryologists2153124embryologists
enologists11310624__enologists
ethnologists1647044ethnologists
ethologists1549024_ethologists
etymologists18156494etymologists
fetologists1547994_fetologists
futurologists1773074futurologists
gemmologists1845234gemmologists
gemologists1577884_gemologists
geohydrologist2371854geohydrologist_
geologists1279164__geologists
gynecologists2053694gynecologists
hematologists19217054hematologists
hierologies1547064hierologi_es
histologist1547984histologist_
horologies14411054h_orologi_es
hydrobiologist24204504hydrobiologist_
hydrocasts1954714hydr__ocasts
hydrofoils2053514hydrofo_i_ls
hydrolases1746284hydrol__ases
hydrology2046214hydrolog___y
hydrolyses2045594hydrol__yses
hydrolysis2045664hydrol__ysis
hydroponics2254774hydroponi_cs
hydrotropisms24102894hydrotropisms
hylozoists2552614hy_lozo_ists
hymnologies2046104hymnologi_es
hypnologies2046084hypnologi_es
ideologist1248534_ideologist_
iridologists1444684iridologists
limnologists1545324limnologists
metrologist14511234metrologist_
mixologists2145684_mixologists
monologists14410074_monologists
museologists1544744museologists
mycologist18410354my_cologist_
myologist15411094my__ologist_
mythologist2059004mythologist_
necrologist14410124necrologist_
neologists1139774__neologists
nephrologists1954984nephrologists
neurologist1249984neurologist_
numerologists1664014numerologists
ologists939444____ologists
oncologists1448074_oncologists
ontologists1248904_ontologists
oologists1039854___oologists
orologist10313104__orologist_
osteologists1346764osteologists
otologists1149634__otologists
papyrologists2154084papyrologists
pathologists1848374pathologists
pedologist14410864ped_ologist_
penologists1449594_penologists
petrologist14711884petrologist_
philologists1876684philologists
phonologists1848774phonologists
phrenologists1956294phrenologists
phycologist2259184phy_cologist_
physiologist21157324physiologist_
pomologists1648984_pomologists
prologist12315084__prologist_
psychologists24127474psychologists
pyrologies16310014py_rologi_es
radiologist1399494radiologist_
rheologists1547314_rheologists
semiologists1548224semiologists
serologist11413154_serologist_
sexologists1947254_sexologists
sinologists1257674_sinologists
sociologists1547944sociologists
syllogists14175174sy__llogists
teleologists1347224teleologists
topologists1447864_topologists
tribologists1546164tribologists
typologist1648894ty_pologist_
ufologists1445424__ufologists
urologist10411054__urologist_
virologist1448814_virologist_
zoologists2047174__zoologists

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901276.44019377.3
3Display Results1271270.0761671.1
 (SQL Overall)1786911276.90625874.7
 
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.