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

146 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
beshames153720(None) 
beshame1447481beshame_
beshamed1635731beshamed
bechamel1754282bechamel
bechamels1853032bechamels
behaves15198522be_haves
beldames1336802beldames
benames112814602be_names
berhymes1843802berhymes
beslimes1246952beslimes
mesdames1346042mesdames
reshapes1338802reshapes
reshaves1438732reshaves
sesames9310742ses_ames
shames114726222__shames
ashamed1336243_ashamed
bashaws15347713basha_ws
bashes115631393bash__es
beamed115720733be__amed
beams95328173be__am_s
became123213163be_came_
bechalks1944793bechalks
bechances1847613bechances
becharmed1944663becharmed
becharms1745343becharms
becomes132911963be_comes
becrimes1467073becrimes
bedamns1235733be_damns
bedframes1743013bedframes
bedlamps1543663bedlamps
bedlams1237053bedlam_s
bedmates1349183bedmates
bedrapes1386963bedrapes
bedtimes1336593bedtimes
beehives1644483beehives
beeswaxes2141983beeswaxes
begazes1937963be_gazes
begrimes1376513begrimes
behalves1644083be_halves
behave14209013be_have_
behaved16176683be_haved
behaver15206723be_haver
behavers16205613be_havers
behoves15177353be_hoves
beldame1237233beldame_
beldams1237053beldam_s
bename103316073be_name_
benamed122911093be_named
berakes134815773be_rakes
berates94126873be_rates
bereaves1338273bereaves
berhyme1743813berhyme_
berhymed1943313berhymed
berimes115216643be_rimes
bermes106023003be__rmes
beseemed1334863beseemed
beseems1175913beseem_s
beses75830723bes___es
beshadow1742303beshadow
beshadows1842513beshadows
beshaming1735673beshaming
beshiver1634483beshiver
beshivers1743713beshivers
beshouts1346763beshouts
beshrew1554393besh_rew
beshrews1643163beshrews
besides104814533bes_ides
besieges1146003besieges
beslaved1435023beslaved
beslime1146833beslime_
beslimed1335013beslimed
besmiles1237393besmiles
besmokes16406363besmokes
besoms105712733bes_om_s
bespake15436963bespake_
beswarmed1743083beswarmed
beswarms1544323beswarms
betakes134212523be_takes
bethanks1765313bethanks
bethumps1741993bethumps
betimes115114413be_times
bewares12313373be_wares
blames105121863b__lames
boscages1366643boscages
boshes114721883bosh__es
boskages1565423boskages
brechams1745773brecham_s
bushes115226113bush__es
bushmen1436303bush_men
bynames14256243b_ynames
defames132812253de_fames
degames113312623de_games
escapes113811673_escapes
estates74520183_estates
ethanes103713513_ethanes
exhales1737143_exhales
exhumes1934323_exhumes
eyeshades1642543eyeshades
gestates93213733gestates
hames106138703___hames
meshes115019443mesh__es
messages1138233messages
methanes133812163methanes
misnames12119883misnames
outshames1445923outshames
pennames12287793pennames
pesades10310903pes_ades
preshapes1667093preshapes
reclames12310893reclames
reframes1338993reframes
renames92418053re_names
resales74724903res_ales
rescales103414573rescales
reshape1249043reshape_
reshaped1437203reshaped
reshaper1336913reshaper
reshapers1435493reshapers
reshave1338603reshave_
reshaved1536873reshaved
reshaven1435193reshaven
reshes94124363resh__es
reshines112615443reshines
reshoes102316033resh_oes
reslates83619503reslates
respaces12311043respaces
respades1139853respades
restages92815773restages
restamps1234703restamps
restates83423433restates
resumes9313373res_umes
sesame8311013ses_ame_
shades105924533__shades
shakes135024593__shakes
shales94731253__shales
shamas113717943__shamas
shame105726703__shame_
shamed125120213__shamed
shammes144312833__shammes
shamos114216983__shamos
shams105829413__sham_s
shamus114112813__shamus
shapes115124953__shapes
shares95236413__shares
shaves125224933__shaves
testates83615453testates
unshamed14148053unshamed

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.420425454.8
2DLD Change Limit1461621467.20320291.8
3Display Results1461460.0632317.5
 (SQL Overall)1786911467.68623248.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.