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

109 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
embattlements195278(None) 
embattlement1853071embattlement_
battlements1544962__battlements
embrittlements2061602embrittlements
battements1455813__batt_ements
battlement1446093__battlement_
embalmments1653843emba__lmments
embezzlements2762003embezzlements
embitterments19102003embitterments
emblements1647793emb___lements
embranglements21132533embranglements
embrittlement1961853embrittlement_
abatements1446354_aba_t_ements
babblements1653394__babblements
bafflements2183454__bafflements
battement1357774__batt_ement_
battlemented1761804__battlemented
belittlements1772064belittlements
debatements1656044deba_t_ements
embalmment1554684emba__lmment_
embankments21183644emba__nkments
embarkments2164004emba__rkments
embattles1342974embattl__e__s
embayments1944514emba___yments
embezzlement2662014embezzlement_
embitterment18102404embitterment_
embracements2055244emb_racements
embranglement20122884embranglement_
embroilments1863314embroil_ments
entanglements1653704entanglements
entitlements1455104e_ntitlements
impalements1746434impa__lements
resettlements1553214resettlements
settlements1345544__settlements
startlements1453394_startlements
unsettlements1562744unsettlements
abasements1446535_aba__sements
abatement1348185_aba_t_ement_
amazements2345315am_a__zements
atonements1247205___atonements
attunements1353725___attunements
babblement1554135__babblement_
bafflement2074165__bafflement_
bailments1346465__ba_il_ments
bamboozlements317945bamboozlements
basements1348265__ba__sements
battlefronts1791325__battlefronts
bedazzlements2681335bedazzlements
belittlement1682495belittlement_
betterments1544715__betterments
cajolements2254165__cajolements
cattlemen1344335__cattlemen__
curettements1652485curett_ements
debasements1666175deba__sements
debatement1547075deba_t_ement_
disablements1754915disa_blements
dismantlements19103025dismantlements
easements11410335e__a__sements
effacements2154875effa__cements
elements10312175e_____lements
embalmers1543775emba__l_me_rs
embankment20114475emba__nkment_
embarkment2084785emba__rkment_
embarrassments20111825embarrassments
embattle1253275embattl__e___
embattled1442565embattl__e__d
embattling1542195embattl__in_g
embayment1845955emba___yment_
embedments1744505emb___edments
emblazonments2861535emblazonments
embodiments1853655emb__odiments
embossments1754035emb__ossments
embracement1956095emb_racement_
embroilment1763965embroil_ment_
emoluments1455425em___oluments
emplacements2054575em_placements
empressements1962835empressements
enactments1446525e_nact__ments
encasements1547455enca__sements
encirclements19133235encirclements
enfeeblements2062215enfeeblements
engagements1546505enga__gements
enhancements1954895enha_ncements
enjambements2552705enja_mbements
enlacements1546995enla__cements
enlargements1555195enla_rgements
ennoblements1654125e_nnoblements
entailments1346355enta_il_ments
entanglement1554085entanglement_
enticements1598165e__nticements
entitlement1355815e_ntitlement_
escapements1744825esca__pements
excitements2254285e_xcit_ements
extolments1944405e__xtol_ments
imbuements1645025imb___uements
impalement1647615impa__lement_
impartments1745355impart__ments
implements1647855im___plements
managements1655315_m_anagements
measurements1653195_measurements
rabblements1753645__rabblements
remeasurements18141485remeasurements
resettlement1453535resettlement_
restatements1455285resta_t_ements
settlement1246475__settlement_
startlement1364135_startlement_
statements1256885_sta_t_ements
tanglements1454745__tanglements
unsettlement1462885unsettlement_

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.373479064.3
2DLD Change Limit1247901098.14315324.8
3Display Results1091090.0761434.2
 (SQL Overall)1786911098.59220797.4
 
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.