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

111 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
planetological195317(None) 
planetologies1653253planetologi_es
planetologist1664503planetologi_st
planetologists1763623planetologists
praxeological2554433praxe_ological
thanatological2062503thanatological
anthological1847504__anthological
antilogical1447254__an_tilogical
climatological2162614climatological
deontological1755174deon_tological
dialectological2162094dialectological
glaciological1963914gla_ciological
gynecological22113784_gynecological
herpetological2253324herpetological
ontological1448314__on_tological
paleoecological2263554paleoecological
paleontological2063844paleontological
palynological2154674p_alynological
parasitological2062774parasitological
pathological2047974p_a_thological
pedological1757614p___edological
penological1648874p___enological
petrological1758594p___etrological
phenological2068054p__henological
phonological2058374phon__ological
phraseological2283694phrase_ological
phrenological2156334p_hrenological
planetoidal1451714planet__o_idal
planetology1752864planetolog___y
primatological2183214primatological
proctological2055824p_roctological
scatological1745544sca__tological
synecological21104114_synecological
tautological1555484_ta_utological
unecological1745824__unecological
abiological1647835__a_biological
algological1545975__a_lgological
analogical1356365__an__alogical
astrological1547025__astrological
audiological1665665__audiological
autecological1854435_autecological
axiological2146875__a_xiological
cardiological1954975_cardiological
cryptological2354795_cryptological
cytological1947455___cytological
dendrological1853835_dendrological
dermatological2053855dermatological
ecological1548705____ecological
enological1348885____enological
epistemological22101945epistemological
eschatological2262465eschatological
ethnological1846815ethn__ological
ethological1748195____ethological
etiological1448415____etiological
gemological1747025___gemological
genealogical1652715_gene_alogical
geological1448075___ge_ological
gerontological1854175gerontological
graphological2253525gra_phological
hagiological1955815_ha_giological
hematological2155945_hematological
histological1846085__histological
iconological1756025icon__ological
ideological15106645__ide_ological
karyological2274735_ka_ryological
lichenological22112835lichenological
limnological1745075_l_imnological
lithological1845895_l_ithological
malacological2053975_malacological
metrological1748375___metrological
mineralogical1862285_mineralogical
museological1754785_muse_ological
myrmecological2662645myrmecological
narratological1763095narratological
necrological1747285___necrological
nematological1855665_nematological
neurological1547335___neurological
nomological1648075___nomological
nonbiological1855265_nonbiological
nosological1447375___nosological
numerological1854015_numerological
oncological1647255__on_cological
ornithological2082455_ornithological
osteological1546375_oste_ological
paleobiological2264735paleobiological
paleozoological2963265paleozoological
pantropical1764345p_an_t_ropical
pharmacological2793545pharmacological
philological2046375p__hilological
phycological2546945p__hycological
physiological2455575p_hysiological
planetesimal1671185planet__esimal
pomological1848035p___omological
prebiological2055975p_rebiological
prelogical1546695p__re__logical
psephological2354985p_sephological
psychological2656595p_sychological
pteridological2053595pteridological
radiological1646985_ra_diological
rheological17127475__rhe_ological
selenological1654665_selenological
serological1468775___serological
sinological1447135_sin__ological
somatological1854885_somatological
speleological1853915spele_ological
stereological1655675stere_ological
teleological1546575_tele_ological
teratological1656115_teratological
theological1798265__the_ological
unideological1763335unide_ological
volcanological2262225volcan__ological

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 Filter178691950240.1101624463.6
2DLD Change Limit950241116.76314050.6
3Display Results1111110.0801387.5
 (SQL Overall)1786911116.95325699.8
 
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.