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

101 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
archaeologists2012281(None) 
archaeologist19113491archaeologist_
archaeologies1952822archaeologi_es
archaeological22152933archaeological
archeologies1845003arch_eologi_es
rheologists1547313_r_h_eologists
anthologists1648034anth__ologists
archaeology2052514archaeolog___y
escapologists1853344esc_apologists
lichenologists2063034lichenologists
narratologists1553214nar_ratologists
oceanologists1654304_oceanologists
primatologists19184354primatologists
rheologist1449534_r_h_eologist_
technologists19125704tech_nologists
trichologists1955424trich__ologists
urbanologists1653254ur_banologists
acarologies1446065a_c_arologi_es
algologists1346145a___lgologists
analogists1147315a__na__logists
angelologists1553375a_ngelologists
anthologist15410465anth__ologist_
anthropologists2183415anthropologists
apologists1348885____apologists
archaists1446585archa_____ists
archeology1954205arch_eolog___y
areologies1139825ar___eologi_es
audiologists1445615a__udiologists
bryologists1745705br___yologists
campanologists2152625campanologists
cardiologists1765145car__diologists
cetologists1449165__c_etologists
chronologists1966115__chronologists
climatologists1983285climatologists
conchologists2154565conch__ologists
cosmologists1746415__cosmologists
criminologists1952975criminologists
cryobiologists2254105cryobiologists
cryptologists2155235cr_yptologists
cytologists1748015__c_ytologists
dermatologists18134925dermatologists
ecologists13310925_ec___ologists
escapologist1754485esc_apologist_
eschatologies1952635eschatologi_es
ethnologists1647045_eth_nologists
ethologists1549025_eth__ologists
geologists1279165____geologists
graphologists20123835gr_aphologists
hematologists19217055_hematologists
horologists1548965___horologists
ichthyologists2662315_ichthyologists
ideologists1346655___ideologists
iridologists1444685ir__idologists
lichenologist1973915lichenologist_
malacologists1854405_malacologists
martyrologists2062895mar_tyrologists
methodologists2153475methodologists
morphologists2154265morph__ologists
museologists1544745__museologists
mycologists1947735myc___ologists
mythologists2146895myth__ologists
narratologist1453835nar_ratologist_
necrologists1547875nec__rologists
nematologists16166605_nematologists
neologists1139775____neologists
neonatologists1584195neonatologists
nephrologists1954985neph_rologists
oceanologist1555685_oceanologist_
oncologists1448075onc___ologists
onomatologists1753335onomatologists
ornithologists1852595ornithologists
orologists1149825or____ologists
osteologists1346765__osteologists
parasitologists1862805parasitologists
pathologists1848375path__ologists
pharmacologists2573645phar_macologists
philologists1876685__philologists
phonologists1848775__phonologists
phraseologists2053575phraseologists
phrenologists1956295__phrenologists
phycologists2367135__phycologists
primatologist18175315primatologist_
proctologists1856815pr_octologists
prologists13311175pr____ologists
psychologists24127475psych__ologists
radiologists1497375_r_adiologists
rheologies1488435_r_h_eologi_es
sociologists1547945soc__iologists
speleologists1654325_speleologists
technologist18137405tech_nologist_
teleologists1347225__teleologists
teratologists1496595_teratologists
thanatologists1852865thanatologists
theologises15106735__th_eologises
tribologists1546165tr__ibologists
trichologist1856745trich__ologist_
urbanologist1554045ur_banologist_
urologists1148415ur____ologists
victimologists2262255victimologists
volcanologists20122765volcanologists
vulcanologists2092305vulcanologists

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.356501941.0
2DLD Change Limit950241016.72014140.5
3Display Results1011010.0801262.5
 (SQL Overall)1786911017.15624970.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.