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

147 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
beshame144748(None) 
beshamed1635731beshamed
beshames1537201beshames
became123213162be_came
bechamel1754282bechamel
behave14209012be_have
beldame1237232beldame
bename103316072be_name
berhyme1743812berhyme
beslime1146832beslime
bespake15436962bespake
reshape1249042reshape
reshave1338602reshave
sesame8311012ses_ame
shame105726702__shame
ashamed1336243_ashamed
bashaw14349303basha_w
bashaws15347713bashaws
beam86939233be__am_
beamed115720733be__amed
beams95328173be__ams
beamy126218573be__amy
bechalk1845803bechalk
bechamels1853033bechamels
bechance1747733bechance
becharm1636843becharm
becharmed1944663becharmed
becharms1745343becharms
become123312593be_come
becrime1387053becrime
bedamn1137813be_damn
bedframe1643023bedframe
bedlam1149273bedlam_
bedlamp1464513bedlamp
bedlams1237053bedlams
bedmate1239433bedmate
bedrape1277693bedrape
bedtime1236973bedtime
beehive1554033beehive
begaze1838333be_gaze
begrime1276553begrime
behalf14310953be_half
behaved16176683be_haved
behaver15206723be_haver
behaves15198523be_haves
behove14207203be_hove
beldam11410113beldam_
beldames1336803beldames
beldams1237053beldams
benamed122911093be_named
benames112814603be_names
berake124216083be_rake
berate84729023be_rate
bereave1258353bereave
berhymed1943313berhymed
berhymes1843803berhymes
berime105317333be_rime
berme96022943be__rme
beseem1069083beseem_
beseemed1334853beseemed
beseems1175913beseems
beshadow1742303beshadow
beshaming1735673beshaming
beshiver1634483beshiver
beshout12311833beshout
beshrew1554393beshrew
beside95114613bes_ide
besiege1035413besiege
beslaved1435023beslaved
beslimed1335013beslimed
beslimes1246953beslimes
besmile1137463besmile
besmoke15416623besmoke
besom95716973bes_om_
besoms105712733bes_oms
bespoke15468113bespoke
beswarm1445773beswarm
beswarmed1743083beswarmed
beswarms1544323beswarms
betake124512703be_take
bethank1666273bethank
bethump1642823bethump
betime105914833be_time
beware11313713be_ware
bistate9313813bistate
blame95625493b__lame
boscage1276533boscage
boskage1465413boskage
brecham1646833brecham_
brechams1745773brechams
bushman1455693bushman
bushmen1436303bush_men
byname13256363b_yname
defame123212433de_fame
degame102713183de_game
escape103811663_escape
estate64719763_estate
ethane94613243_ethane
exhale1636873_exhale
exhume1833803_exhume
eyeshade1542583eyeshade
gestate83614073gestate
hame97043133___hame
mesdames1346043mesdames
message1037833message
methane123211793methane
misname11119483misname
outshame1346743outshame
penname11328553penname
pesade9311103pes_ade
preshape1537533preshape
reclame11411063reclame
reframe1239393reframe
rename82718813re_name
resale64025543res_ale
rescale93215473rescale
reshaped1437203reshaped
reshaper1336913reshaper
reshapes1338803reshapes
reshaved1536873reshaved
reshaven1435193reshaven
reshaves1438733reshaves
reshine102816943reshine
reshoe92816483resh_oe
reshone102414163reshone
reslate73520593reslate
respace11310913respace
respade1039573respade
restage83316183restage
restamp1146483restamp
restate73824873restate
resume8313783res_ume
same65245643__s_ame
sesames9310743ses_ames
shade95125583__shade
shake124726403__shake
shale85332833__shale
sham96436353__sham_
shamed125120213__shamed
shames114726223__shames
shams105829413__shams
shape105125113__shape
share86437083__share
shave114425893__shave
testae64216253testa_e
testate73916233testate
unshamed14148053unshamed

Search took 7 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 Filter1786911340270.1701051123.5
2DLD Change Limit1340271476.73619897.1
3Display Results1471470.0602450.0
 (SQL Overall)1786911476.96625651.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.