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

105 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
archeologies184500(None) 
archaeologies1952821archaeologies
areologies1139822ar__eologies
rheologies1488432_r_heologies
acarologies1446053a_carologies
anthologies151012013anth_ologies
archaeologist19113493archaeologist
archaeologists20122813archaeologists
archeology1954203archeolog__y
ichnologies1746353_ichnologies
lichenologies1952913lichenologies
praxeologies2293823praxeologies
sarcologies1446433sarc__ologies
technologies1845973technologies
theologies141010103__theologies
trichologies1845573trich_ologies
aerobiologies1655054aerobiologies
aerologies11312024a__erologies
aetiologies1248984a_etiologies
agrologies1237694a__grologies
algologies1246794a__lgologies
amphibologies2352414amphibologies
andrologies1346114a_ndrologies
anemologies1446924a_nemologies
angelologies1453014angelologies
angiologies1346134a_ngiologies
anthologizes253038394anth_ologizes
apiologies1339064a__piologies
apologies12311194a___pologies
archaeological22152934archaeological
archaeology2052514archaeolog__y
archenemies1852634arche_nemies
archeries14411224arche___ries
astrologies1247924a_strologies
audiologies1345624a_udiologies
autecologies1554574autecologies
axiologies1837484a__xiologies
balneologies1553314balneologies
bryologies1646044br__yologies
cardiologies1644954car_diologies
carpologies1646404car__pologies
cetologies13410854__cetologies
conchologies2054564conch_ologies
craniologies1545374craniologies
cryptologies2055424cryptologies
cytologies1639264__cytologies
ecologies12312354_ec__ologies
escapologies1753224escapologies
eschatologies1952634eschatologies
ethnologies1547984_ethnologies
ethologies14310544_eth_ologies
garbologies1544884gar__bologies
geologies11410644___geologies
graphologies1963734graphologies
iconologies1447084_iconologies
ideologies1237334__ideologies
iridologies1344584ir_idologies
karyologies1944444kar__yologies
laryngologies18122144laryngologies
lithologies1546834lith_ologies
martyrologies1952334martyrologies
morphologies2044524morph_ologies
museologies1444544_museologies
mycologies1848864myc__ologies
mythologies2047844myth_ologies
narratologies1452754narratologies
necrologies1447984nec_rologies
neologies10411714___neologies
nephologies1747354neph_ologies
nephrologies1845074nephrologies
oecologies1339464oec__ologies
oncologies1348654onc__ologies
ophiologies1746014_ophiologies
organologies1454084organologies
orismologies1553294orismologies
orologies10311624or___ologies
osteologies1247054_osteologies
paleologies1448574_paleologies
pathologies1748734path_ologies
phenologies1749354__phenologies
phraseologies1953274phraseologies
proctologies1746314proctologies
psychologies23127854psych_ologies
radiologies1347804_radiologies
rheologic1545744_r_heologi_c
rheologist1449534_r_heologist
rheologists1547314_r_heologists
rhinologies1546504_rhinologies
scatologies1446864_scatologies
sociologies1447804soc_iologies
speleologies1553884speleologies
stereologies1345914stereologies
technologizes2853424technologizes
teleologies1247514_teleologies
theologise14117744__theologise
theologises15106734__theologises
theologizes24106064__theologizes
theologues14124404__theologues
tocologies1349764toc__ologies
tracheotomies2062844tracheotomies
tribologies1446124tr_ibologies
tropologies1447734tr_opologies
uranologies1246134ur_anologies
urbanologies1552964urbanologies
urologies1039534ur___ologies

Search took 9 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 Limit1247901058.14015330.5
3Display Results1051050.0631666.7
 (SQL Overall)1786911058.34321418.1
 
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.