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

104 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
escapements174482(None) 
escapement1645861escapement_
encasements1547452encasements
escarpments1753442escarpments
casements1348583__casements
easements11410333e__asements
effacements2154873effacements
elopements14146363e_lopements
encampments19103933encampments
encasement1448703encasement_
encashments1875063encashments
engagements1546503engagements
enlacements1546993enlacements
enslavements1754123enslavements
escapees12336333escape_e__s
escarpment1644093escarpment_
excitements2254283excitements
excrements2146983exc_rements
restatements1455283restatements
securements1545493securements
statements1256883_statements
abasements1446534_abasements
abatements1446354_abatements
accruements1753774accruements
amazements2345314_amazements
assuagements1552974assuagements
basements1348264__basements
bereavements19154204bereavements
capelets1268604__capele_ts
casement12311954__casement_
cements112714224__c__ements
cerements13411454__cerements
debasements1666174debasements
debatements1656044debatements
decampments2073524decampments
decrements1549384dec_rements
defacements1946074defacements
depravements2054454depravements
despisements1785164despisements
easement10414164e__asement_
effacement2045374effacement_
elements10312174e___lements
elopement13118224e_lopement_
embalmments1653844embalmments
embankments21183644embankments
embarkments2164004embarkments
embayments1944514emba_yments
emblements1647794e_mblements
embracements2055244embracements
emplacements2054574emplacements
enactments1446524e_nactments
encampment1894874encampment_
encashment1746114encashment_
enchainments1953484enchainments
enchantments1953404enchantments
encipherments2262014encipherments
encystments1853624encystments
enframements1954624enframements
engagement1447514engagement_
enhancements1954894enhancements
enjambements2552704enjambements
enjambments2462904enjambments
enlacement1458144enlacement_
enlargements1555194enlargements
enslavement1654634enslavement_
entailments1346354entailments
enticements1598164enticements
entrapments1546294entrap_ments
equipments2344024equip_ments
escapades1442994escapade__s
escapee113310464escape_e___
escapers12337414escap__e_rs
escapes113811674escap__e__s
escapists1344254escap__ists
esculents1144694esc__ulents
estrangements1684404estrangements
evolvements1953744evolvements
excipients2152724excip_ients
excitement2154874excitement_
excrement2048064exc_rement_
impalements1746434impalements
incitements1556294incitements
increments14410104inc_rements
managements1655314managements
pavements1647004__pavements
placements1645974_placements
ravagements1754164ravagements
recements13312284rec__ements
recrements1449354rec_rements
replacements1854444replacements
rescindments1752794rescindments
restatement1356264restatement_
sacraments1445854_sacraments
sapients1037424_s_ap_ients
sarments10311964_s_a_rments
scapegoats1552034_scapegoats
securement1446494securement_
seducements1654494seducements
settlements1345544settlements
shipments16254704_ship_ments
solacements1554384solacements
statement1148794_statement_
supplements1754594_supplements
testaments1265354testa__ments

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 Filter1786911488190.406440125.6
2DLD Change Limit1488191048.25018038.7
3Display Results1041040.0631650.8
 (SQL Overall)1786911048.71920494.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.