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 “encamped” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

119 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
encamped153502(None) 
camped134720232__camped
decamped1634962decamped
encaged113211082enca_ged
encamp1235942encamp__
encamps1335422encamp_s
encased103512312enca_sed
encashed14246472encashed
enclasped1454212enclasped
enjambed2042822enjambed
escaped12388852esca_ped
escarped1355162escarped
scamped144711962_scamped
uncapped1556692uncapped
unclamped1664502unclamped
undamped1445332undamped
amped104820513___amped
becapped1733933becapped
benamed122911093ben_am_ed
camper124722213__camper
caped104931803__ca_ped
capped134721853__capped
carped115923763__carped
champed174111483_champed
clamped144012043_clamped
comped135919873__comped
cramped144712183_cramped
damped124315583__damped
enabled102510633en_abled
enacted10310643en_acted
enamel81210113en_am_el
enameled1136373en_ameled
enamored1147033en_amored
encage93713503enca_ge_
encages103313783enca_ges
encamping1645233encamping
encampment1894873encampment
encase83714363enca_se_
encases93116053enca_ses
encashes13227673encashes
enchained1545493enchained
enchanted1546553enchanted
enchased1437383enchased
enclaved1456343enclaved
enclosed1198253enclosed
encoded1139033enc_oded
encored10412103enc_ored
encrypted1743183encrypted
encumber1454143encumber
encysted1444293encysted
endamaged1442773endamaged
enfaced13218913enfa_ced
enflamed1455723enflam_ed
enframed1466263enfram_ed
engaged10379833enga_ged
enhaloed12125933enhaloed
enhanced1436623enhanced
enlaced102410523enla_ced
enlarged1035413enlarged
enraged93511783enra_ged
ensample1242983ensample
ensamples1343123ensamples
entailed989523entailed
entombed13104503entombed
entrapped1484873entrapped
enwombed16122943enwombed
enwrapped1742793enwrapped
escaloped1443983escaloped
escape103811663esca_pe_
escapee113310463esca_pee
escaper11368843esca_per
escapes113811673esca_pes
exampled2043353e_xampled
incaged114010443inca_ged
incanted11259543incanted
incased103612393inca_sed
inclasped1463553inclasped
knapped16397103kn_apped
lamped114017543__lamped
named85223063_n_am_ed
napped114218163_n_apped
ramped114617903__ramped
recapped1535943recapped
renamed103114523ren_am_ed
restamped1444433restamped
revamped1634143revamped
scalped124411993_scalped
scammed14479543_scammed
scamper134613163_scamper
scaped115519553_sca_ped
scarped124314403_scarped
snapped124611203sn_apped
sneaped10338813snea_ped
stamped124812813_stamped
swamped15498443_swamped
tamped114317043__tamped
tramped124312433_tramped
uncaged113314123unca_ged
uncaked143514353unca_ked
uncalled11810923uncalled
uncanned11289963uncanned
uncarded12310133uncarded
uncarted11312053uncarted
uncarved1438163uncarved
uncased104216953unca_sed
uncashed14299763uncashed
uncasked15278453uncasked
uncaused1138453uncaused
unclasped1465503unclasped
uncombed1536323uncombed
unjammed2033623unjammed
unmapped1535173unmapped
unnamed102410273unnam_ed
unsampled1444443unsampled
unstamped1454603unstamped
untamed102913223untam_ed
untapped1376613untapped
unwarped1436873unwarped
vamped144211013__vamped

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621197.09320606.5
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.56223630.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.