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

105 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
diabetologists1812281(None) 
diabetologist17133141diabetologist_
dialectologists1992392dialectologists
dialectologist1882683dialectologist_
planetologists1763623planetologists
cetologists1449164___cetologists
cosmetologists1953144cosmetologists
deontologists1555924d_eontologists
dermatologists18134924dermatologists
diabolists1354464diab__ol__ists
dialectologies1892084dialectologi_es
dialogists1265604dia____logists
fetologists1547994___fetologists
herpetologists2083634herpetologists
histologists1646294hi__stologists
ideologists1346654_i_de_ologists
lichenologists2063034lichenologists
planetologist1664504planetologist_
thanatologists1852864thanatologists
algologists1346145__a_lgologists
angelologists1553375_angelologists
anthologists1648035__anthologists
apologists1348885__a__pologists
audiologists1445615__audiologists
biologists1349435___b_iologists
bryologists1745705___bryologists
cardiologists1765145_cardiologists
cetologist13412255___cetologist_
climatologists1983285climatologists
cosmetologist1853975cosmetologist_
cryptologists2155235_cryptologists
cytologists1748015___cytologists
demonologists1755565d_emonologists
dendrologists1654085d_endrologists
deontologist1457415d_eontologist_
dermatologist1786465dermatologist_
diabolisms1573835diab__ol__isms
diabolist1256495diab__ol__ist_
dialectological2162095dialectological
dialogist1148275dia____logist_
ecologists13310925____ecologists
embryologists2153125_embryologists
enologists11310625____enologists
epistemologists2072125epistemologists
ethologists1549025____ethologists
exobiologists2355325exob_iologists
fetologist14410405___fetologist_
gemologists1577885___gemologists
geologists1279165___ge_ologists
gerontologists1654855gerontologists
glaciologists1753945gla_ciologists
graphologists20123835gra_phologists
gynecologists2053695_gynecologists
hematologists19217055_hematologists
herpetologist1984795herpetologist_
histologist1547985hi__stologist_
ideologist1248535_i_de_ologist_
immunologists18124495_immunologists
iridologists1444685_i_ridologists
lichenologist1973915lichenologist_
limnologists1545325li__mnologists
malacologists1854405_malacologists
metrologists1588835___metrologists
mineralogists1652315mi_neralogists
mixologists2145685mi___xologists
museologists1544745_muse_ologists
myrmecologists2452785myrmecologists
narratologists1553215narratologists
nematologists16166605_nematologists
neologists1139775___ne_ologists
neonatologists1584195neonatologists
nonbiologists1664725nonb_iologists
numerologists1664015_numerologists
onomatologists1753335onomatologists
ontologists1248905___ontologists
osteologists1346765_oste_ologists
otologists1149635____otologists
paleontologists1884525_paleontologists
palynologists1954995_palynologists
papyrologists2154085_papyrologists
parasitologists1862805parasitologists
pathologists1848375_pa_thologists
pedologists1548275___pedologists
penologists1449595___penologists
petrologists1559145___petrologists
phraseologists2053575phrase_ologists
phrenologists1956295_phrenologists
planetologies1653255planetologi_es
primatologists19184355primatologists
proctologists1856815_proctologists
radiobiologists19174265radiob_iologists
radiologists1497365_ra_diologists
rheologists1547315__rhe_ologists
selenologists1455335_selenologists
serologists12410125___serologists
sexologists1947255___sexologists
sinologists1257675si___nologists
speleologists1654325spele_ologists
teleologists1347225_tele_ologists
teratologists1496595_teratologists
thanatologist1753615thanatologist_
tribologists1546165trib__ologists
urbanologists1653255_urbanologists
victimologists2262255victimologists
virologists1546635vi___rologists

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 Filter178691950240.343520965.0
2DLD Change Limit950241056.59314412.9
3Display Results1051050.0631666.7
 (SQL Overall)1786911056.99925530.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.