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

115 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
climatologist187394(None) 
climatologists1983281climatologists
climatologies1852802climatologies
primatologist18175312primatologist
climatological2162613climatological
climatology1952373climatolog__y
cosmetologist1853973cosmetologist
criminologist1863643criminologist
dermatologist1786463dermatologist
hematologist18219203_hematologist
limnologist1446683_lim_nologist
nematologist15208473_nematologist
onomatologist1654403onomatologist
primatologists19184353primatologists
campanologist2053384campanologist
cetologist13412254c___etologist
cosmetologists1953144cosmetologists
cosmologist1648374cosm__ologist
criminologists1952974criminologists
cryptologist2056434c_ryptologist
cytologist16410534c___ytologist
dermatologists18134924dermatologists
hematologists19217054_hematologists
histologist1547984_hi_stologist
limnologists1545324_lim_nologists
narratologist1453834narratologist
nematologists16166604_nematologists
neonatologist14135354neonatologist
onomatologists1753334onomatologists
planetologist1664504planetologist
primatologies1863874primatologies
rheumatologist2062854rheumatologist
teratologist13108574_teratologist
thanatologist1753614thanatologist
algologist1248245al___gologist
apologist12412405____apologist
archaeologist19113495archaeologist
biologist12412345_bi___ologist
campanologists2152625campanologists
cardiologist1656615c_ardiologist
cetologists1449165c___etologists
chronologist1857625c_hronologist
conchologist2055815c_onchologist
cosmetologies1852925cosmetologies
cosmologists1746415cosm__ologists
criminologies1852955criminologies
cryobiologist2154525cryobiologist
cryptologists2155235c_ryptologists
cytologists1748015c___ytologists
demonologist1657055_demonologist
deontologist1457415_deontologist
dermatologic1854495dermatologi_c
dermatologies1755255dermatologies
diabetologist17133145diabetologist
dialogist1148275_di_a__logist
electrologist1657015electrologist
escapologist1754485_escapologist
etymologist17158025etym__ologist
fetologist14410405___fetologist
gemmologist1746545_gem_mologist
gemologist141010285_gem__ologist
gerontologist1555985gerontologist
glaciologist1654895gl_aciologist
hematologic1956355_hematologi_c
hematologies1847545_hematologies
herpetologist1984795herpetologist
histologists1646295_hi_stologists
ideologist1248535__i_deologist
immunologist17135325_immunologist
iridologist1345795__iridologist
lexicologist2294915_lexicologist
lichenologist1973915_lichenologist
limnologic1553535_lim_nologi_c
limnologies1445535_lim_nologies
malacologist1755635_malacologist
mammalogist1553065mamma__logist
metrologist14511225___metrologist
mixologist2047695___mixologist
monologist13413615___monologist
mycologist18410355___mycologist
myologist15411095___m_yologist
myrmecologist2353315myrmecologist
mythologist2058995___mythologist
narratologists1553215narratologists
nematologies1546685_nematologies
neonatologists1584195neonatologists
numerologist1574915_numerologist
oceanologist1555685_oceanologist
onomatologies1653385onomatologies
ontologist11411365___ontologist
otologist10412815____otologist
paleontologist1765145paleontologist
pathologist17410665___pathologist
pharmacologist2464175pharmacologist
philologist1768435phi__lologist
planetologists1763625planetologists
pomologist15412045_pom__ologist
primatological2183195primatological
primatology1953455primatolog__y
proctologist1758965_proctologist
rheumatologists2162255rheumatologists
sedimentologist1992115sedimentologist
seismologist15125275sei_smologist
semiologist14410715_sem_iologist
sinologist11510665_si__nologist
somatologies1546225_somatologies
teratologists1496585_teratologists
thanatologists1852865thanatologists
tribologist1447725tri__bologist
trichologist1856745tri_chologist
urbanologist1554045_urbanologist
victimologist2162625victim__ologist
virologist1448815_vi__rologist
volcanologist1993165volcanologist
vulcanologist1982705vulcanologist

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.1401276364.3
2DLD Change Limit1247901159.09313723.7
3Display Results1151150.0801437.5
 (SQL Overall)1786911159.31319187.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.