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

125 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
becapped173393(None) 
recapped1535941recapped
becalmed1534812becalmed
becarpet1447532becarpet
beclasped1643742beclasped
bewrapped1962512bewrapped
capped134721852__capped
decamped1634962decamped
icecapped1841432icecapped
remapped1534912remapped
uncapped1556692uncapped
beached154516553be_ached
beaconed1336983beaconed
beaded104922423be_a_ded
beaked135919493be_a_ked
beamed115720733be_a_med
beaned95621473be_a_ned
bearded114212133be_arded
bebopper1642103bebopper
became123213163beca_me_
becap114315053beca_p__
becapping1834243becapping
becaps123811403beca_p_s
becarpeted1742263becarpeted
becarpets1542913becarpets
because1136233because_
bechalked2143593bechalked
bechanced1945643bechanced
becharmed1944663becharmed
becked155417763bec__ked
beckoned1735783beckoned
becrawled1743123becrawled
becrimed1565513becrimed
becursed1335583becursed
bedamned1434583bedamned
bedaubed1443183bedaubed
bedraped1455813bedraped
beeped115313453be__eped
begalled1236023begalled
begazed2036203bega_zed
behaved16176683beha_ved
belaced124112153bela_ced
beladied1236663beladied
belated103520013bela_ted
belauded1244793belauded
belayed133610083bela_yed
beleaped1336103beleaped
benamed122911093bena_med
beraked144312433bera_ked
berated104422133bera_ted
betaxed17307023beta_xed
bewailed1435343bewailed
bewared13310113bewa_red
bitmapped1841433bitmapped
blipped14377193b_lipped
bopped134413403b__opped
camped134720233__camped
caped104931803__ca_ped
capper124421983__capper
carped115923763__carped
chapped172711443_chapped
clapped143511173_clapped
copped135221253__copped
crapped143912623_crapped
cupped134413983__cupped
dapped124516763__dapped
decanted122310493decanted
decapod1335433deca_pod
decayed14309333deca_yed
decupled1494983decupled
dewlapped1841953dewlapped
elapsed1056103_elapsed
encamped1535023encamped
escaped12388853esca_ped
escarped1355163escarped
exapted1736073_exapted
flapped15328253_flapped
frapped15318853_frapped
gapped124217123__gapped
happed144820103__happed
heaped124516903he_a_ped
kepped15309543ke__pped
knapped16397103_knapped
kneecapped2151083kneecapped
lapped114320033__lapped
leaped94317773le_a_ped
mapped134015883__mapped
mudcapped1941383mudcapped
napped114218163__napped
pepped103113403pe__pped
petnapped1342383petnapped
rapped114122683__rapped
reaped94122453re_a_ped
recalled11310803recalled
recaned102817203reca_ned
recanted112513513recanted
recarpet12310603recarpet
reclasped1444863reclasped
recopied1339843recopied
recouped13128663recouped
redipped1434783redipped
relapsed1136523relapsed
repped114616723re__pped
retaped103814283reta_ped
revamped1634143revamped
rewrapped1763023rewrapped
sapped114422013__sapped
scalped124411993_scalped
scamped144711963_scamped
scaped115519553_sca_ped
scarped124314403_scarped
scrapped1556533scrapped
slapped123511843_slapped
snapped124611203_snapped
strapped1357823strapped
swapped15429143_swapped
tapped113820053__tapped
trapped124512213_trapped
unmapped1535173unmapped
untapped1376613untapped
wapped144416473__wapped
whapped18367573_whapped
wrapped15338023_wrapped
yapped144415143__yapped
zapped204213523__zapped

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 Limit1461621256.89021213.6
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.35924282.0
 
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.