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

113 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
tropological174661(None) 
topological1647401t_opological
tribological1745952tribological
tropologic1556062tropologic__
tropologically2264182tropologically
typological1946662t_ypological
anthropological2373103anthropological
bryological1945373br_yological
chronological2175923chronological
cryptological2354793cryptological
graphological2253523graphological
homological1948413_homological
horological1748253_horological
iconological1756003iconological
morphological2353943morphological
nomological1648053_nomological
nosological1447343_nosological
oological1248303__o_ological
phonological2058333phonological
pomological1848003_pomological
proctological2055793proctological
rheological17127453_rheological
tautological1555463tautological
teleological1546553teleological
teratological1656113teratological
theological1798243t_heological
topologic1446983t_opologic__
topologically2165373t_opologically
tropologies1447723tropologi_es
urological1347753ur__ological
zoological2246423_zo_ological
abiological1647814_abiological
aerobiological1955094aerobiological
algological1545954_algological
anthological1847484anthological
astrological1546984astrological
audiological1665654audiological
axiological2146864_axiological
biological15128864__biological
cardiological1954964cardiological
cohomological2354054cohomological
cosmological1946064cosmological
cryobiological2463884cryobiological
cytological1947434_cytological
demonological1954944demonological
deontological1755154deontological
ecological1548704__ecological
enological1348884__enological
entomological1855004entomological
ethnological1846794ethnological
ethological1748174_ethological
etiological1448384_etiological
etymological2045854etymological
exobiological2554684exobiological
gemological1747014_gemological
geological1448064__geological
geopolitical1752504geopolitical
gerontological1854154gerontological
hagiological1955784hagiological
histological1846064histological
hydrological2246464hydrological
ideological15106634_ideological
karyological2274734karyological
limnological1745074limnological
lithological1845874lithological
meteorological1953764meteorological
methodological2353284methodological
metrological1748354metrological
museological1754774museological
mycological2147114_mycological
mythological2346884mythological
necrological1747284necrological
neurological1547334neurological
nonlogical1347054_no_nlogical
oncological1647234_oncological
ontological1448284_ontological
orismological1853604orismological
osteological1546344osteological
pathological2047934pathological
pedological1757594_pedological
penological1648854_penological
petrological1758564petrological
phenological2068024phenological
philological2046344philological
phrenological2156304phrenological
phycological2546914phycological
praxeological2554414praxeological
prebiological2055934prebiological
prelogical1546684pr__elogical
psephological2354964psephological
pteridological2053564pteridological
radiological1646974radiological
scatological1745524scatological
semiological1747774semiological
serological1468774_serological
sinological1447134_sinological
sociological1747474sociological
stereological1655654stereological
technological2155144technological
terminological1953644terminological
toploftical1851814t_oploftical
topologies1348974t_opologi_es
topologist13410644t_opologi_st
topologists1447864t_opologists
toponymical2052024t_oponymical
toxicological2553954toxicological
tropical1248734trop____ical
tropology1546424tropolog___y
typologic1746144t_ypologic__
typologically2465164t_ypologically
ufological1644904__ufological
unecological1745824unecological
virological1746304_virological

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 Filter1786911247900.1401276364.3
2DLD Change Limit1247901137.17317397.2
3Display Results1131130.0631793.7
 (SQL Overall)1786911137.37624226.0
 
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.