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 “archaeological” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
archaeological2215292(None) 
archaeologies1952823archaeologi_es
archaeologist19113493archaeologi_st
archaeologists20122803archaeologists
eschatological2262463eschatological
rheological17127443_r_h_eological
anthological1847484anth__ological
archaeology2052514archaeolog___y
archeologies1845004arch_eologi_es
lichenological22112834lichenological
narratological1763094nar_ratological
praxeological2554404pr_axeological
primatological2183194primatological
scatological1745524_sc_atological
technological2155144tech_nological
theological1798234__th_eological
abiological1647815a___biological
aerobiological1955095aerobiological
algological1545955a___lgological
analogical1356365a__na__logical
anthropological2373105anthropological
archaical1645905archa_____ical
archegonial1751995arch_e_goni_al
archeology1954205arch_eolog___y
archesporial1962335arch_espori_al
archetypical2461455arch_e_typical
astrological1546985a__strological
audiological1665655a__udiological
autecological1854415a_utecological
axiological2146865a___xiological
bryological1945375br___yological
cardiological1954965car__diological
chronological2175915__chronological
climatological2162615climatological
cohomological2354045_cohomological
cosmological1946065__cosmological
criminological21102775criminological
cryobiological2463885cryobiological
cryptological2354795cr_yptological
cytological1947435__c_ytological
dermatological2053855dermatological
ecological1548705_ec___ological
ethnological1846785_eth_nological
ethological1748175_eth__ological
geological1448055____geological
graphological2253525gr_aphological
hagiological1955775___hagiological
hematological2155925_hematological
homological1948405___homological
horological1748245___horological
ichthyological2882425_ichthyological
iconological1756005_ic_onological
ideological15106635___ideological
karyological2274735kar___yological
lithological1845875lith__ological
malacological2053975_malacological
methodological2353285methodological
morphological2353945morph__ological
museological1754775__museological
mycological2147105myc___ological
mythological2346885myth__ological
necrological1747285nec__rological
nematological1855665_nematological
nonideological1862485nonideological
nontheological2063175nontheological
oncological1647235onc___ological
orismological1853605or_ismological
ornithological2082455ornithological
osteological1546335__osteological
parasitological2062755parasitological
pathological2047925path__ological
pharmacological2793505phar_macological
phenological2068015__phenological
philological2046325__philological
phonological2058325__phonological
phraseological2283655phraseological
phrenological2156295__phrenological
phycological2546905__phycological
prebiological2055935pr_ebiological
prelogical1546685pr___e_logical
proctological2055785pr_octological
psychological2656575psych__ological
radiological1646975_r_adiological
rheologic1545745_r_h_eologic__
rheologically2255265_r_h_eologically
sociological1747475soc__iological
somatological1854855_somatological
speleological1853905_speleological
stereological1655645_stereological
teleological1546545__teleological
teratological1656115_teratological
thanatological2062485thanatological
tribological1745955tr__ibological
tropological1746615tr__opological
unchronological2362325unchronological
unideological1763325_unideological
urological1347755ur____ological
volcanological2262205volcanological

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.1261418182.5
2DLD Change Limit95024986.92313725.8
3Display Results98980.0761289.5
 (SQL Overall)178691987.12525079.4
 
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.