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

121 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
pteridological205359(None) 
pedological1757613p_e__dological
petrological1758593petr__ological
prebiological2055973prebi_ological
pteridologies1762933pteridologi_es
pteridologist17144603pteridologi_st
pteridologists18133723pteridologists
soteriological1763893soteri_ological
stereological1655673ster_eological
teratological1656113_teratological
terminological1953643_terminological
tribological1745983_t_ribological
bacteriological2282864bacteri_ological
cardiological1954974_cardiological
etiological1448414__eti_ological
methodological2353304methodological
metrological1748374metr__ological
penological1648874p_e__nological
phenological2068054phe__nological
philological2046374p__hilological
phrenological2156334p_hrenological
physiological2455574physi_ological
psephological2354984pse_phological
pteridology1852594pteridolog___y
semiological1747784_semi_ological
serological1468774_ser__ological
technological2155144_technological
teleological1546574_te_leological
toxicological2553984_toxicological
tropological1746634_t_ropological
abiological1647835__abi_ological
aerobiological1955135_aerobiological
anthropological2373105anthropological
astrological1547025astr__ological
audiological1665665_audi_ological
autecological1854435aute__cological
axiological2146875__axi_ological
biological15128885___bi_ological
bryological1945375__br_yological
chronological2175955_chronological
codicological1853895_codicological
criminological21102775criminological
demonological1954965_demonological
dendrological1853835_dendrological
deontological1755175_deontological
dermatological2053855_dermatological
ecological1548705__e__cological
embryological2353185embr_yological
enological1348885__e__nological
epidemiological23172605epidemi_ological
ethnological1846815__ethnological
ethological1748195__e_thological
etymological2045875__etymological
exobiological2554725exobi_ological
futurological1952985futur__ological
gemological1747025_ge__mological
geological1448075_ge___ological
gerontological1854175_gerontological
glaciological1963915glaci_ological
hagiological1955815_hagi_ological
hematological2155945_hematological
herpetological2253325_herpetological
horological1748285_hor__ological
hydrological2246485hydr__ological
ideological15106645____ideological
karyological2274735_kar_yological
meteorological1953785meteorological
morphological2353965_morphological
musicological2053545_musicological
narratological1763095narratological
necrological1747285_ne_crological
nematological1855665_nematological
neurological1547335_ne_urological
nonbiological1855265nonbi_ological
nonideological1862525_nonideological
numerological1854015numer__ological
orismological1853625__orismological
osteological1546375oste___ological
paleobiological2264735paleobiological
paleoecological2263555paleoecological
paleontological2063845paleontological
paleozoological2963265paleozoological
palynological2154675p_alynological
parasitological2062775parasitological
pathological2047985p__athological
pedagogical1852275p_e__dagogical
pedologic1546975p_e__dologic__
periodical1546815p_eri___odical
petrologic1547735petr__ologic__
petrologically2256065petr__ologically
pharmacological2793545pharmacological
phonological2058375p__honological
photobiological2564455photobi_ological
phraseological2283695phraseological
phycological2546945p__hycological
planetological1953175planetological
pomological1848035p___omological
praxeological2554435p_raxeological
prebiologic1884735prebi_ologic__
prelogical1546695p__r__elogical
primatological2183215primatological
proctological2055825p_roctological
psychological2656595p_sychological
radiological1646985___radiological
rheological17127475___rheological
seismological1873965_seismological
selenological1654665_selenological
sinological1447135___sinological
sociological1747505_soci_ological
speleological1853915spe_leological
stereologically2163515ster_eologically
tautological1555485_t_autological
teratologic1455655_teratologic__
theological1798265_t__heological
topological1647435_t__opological
typological1946685_t__ypological
unecological1745825une__cological
unideological1763335__unideological
urological1347755__ur__ological
vexillological2761685_vexillological
virological1746305___virological

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.356501941.0
2DLD Change Limit950241215.98615874.4
3Display Results1211210.0931301.1
 (SQL Overall)1786911216.43527768.6
 
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.