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

127 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
beggared133475(None) 
begazed2036202be_gazed
beggar10328222beggar__
beggaries1356232beggaries
beggarly15293392beggarly
beggars11378222beggar_s
beggarweed1851112beggarweed
beggary14316152beggar_y
begged115013812begg__ed
bewared13310112be_wared
buggered1335622buggered
regeared1039432regeared
saggared11326062saggared
badgered1336213badgered
baggage1235633baggage_
baggages1335443baggages
bagged114519903bagg__ed
bared85144483b___ared
beaded104922423be__aded
beaked135919493be__aked
beamed115720733be__amed
beaned95621473be__aned
beard86024963be__ar_d
bearded114212133be__arded
bearer85323913be__arer
beavered1437503beavered
becharmed1944663becharmed
bedraped1455813bedraped
bedward1497473bedwar_d
bedwarfed1942353bedwarfed
beeyard1335523beeyar_d
begalled1236023begalled
begaze1838333be_gaze_
begazes1937963be_gazes
beggardom1651263beggardom
beggaring1435183beggaring
beggarweeds195633beggarweeds
begird1036823be_gir_d
begirded1334173begirded
beglad10138463begla__d
begladded1542863begladded
beglamored1672233beglamored
begoggled1541713begoggled
begrimed1475213begrimed
begroaned13124053begroaned
beguiled1244443beguiled
begulfed1552603begulfed
behaved16176683be_haved
beheaded1536373beheaded
belaced124112153be_laced
belated103520013be_lated
belayed133610083be_layed
beleaped1336103beleaped
bemeaned1335783bemeaned
bemired123410633be_mired
bemoaned1335553bemoaned
benamed122911093be_named
bendayed1534873bendayed
beraked144312433be_raked
berated104422133be_rated
bereaved1446403bereaved
bergere1068913bergere_
bergeres1189113bergeres
beshamed1635733beshamed
beslaved1435023beslaved
besmeared1443423besmeared
beswarmed1743083beswarmed
betaxed17307023be_taxed
betrayed1436303betrayed
bettered113011833bettered
beware11313713be_ware_
bewares12313373be_wares
bewearied1544203bewearied
bewrayed1733933bewrayed
blared95018243b__lared
bleared104211253b_leared
bogarted1235053b_ogarted
bogged116019283bogg__ed
boggled12409003bogg_led
brigaded1344573brigaded
bugged114318403bugg__ed
cellared11398793cellared
daggered12246403daggered
declared1248743declared
deglazed2034953deglazed
degraded12288323degraded
desugared1242663desugared
dogeared1145793dogeared
eared65139503_e__ared
eggar7458883_eggar__
eggars8398973_eggar_s
egged85114393_egg__ed
engaged10379833_engaged
feared106320433fe__ared
geared85317743__geared
gewgawed1741103gewgawed
glared84715193__glared
haggard13377183haggar_d
hangared1337573hangared
jiggered1834203jiggered
kegged13469263kegg__ed
laggard10347623laggar_d
legated92513983le_gated
legged95713093legg__ed
neared75119803ne__ared
negated93413233ne_gated
niggard1044943niggar_d
niggarded1342643niggarded
pegged114811913pegg__ed
puggaree12174333puggaree
reared75930013re__ared
regaled93615963re_galed
regard85215773re_gar_d
regarded11279803re_garded
reggae858953regga_e_
reggaes948883regga_es
reglazed1935743reglazed
regraded113410763regraded
regrated102816333regrated
saggard10358953saggar_d
saggered11237553saggered
seared75232843se__ared
seggar8357813seggar__
seggars9377783seggar_s
sugared938583_sugared
teared75722153te__ared
vegged124910023vegg__ed

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.406440125.6
2DLD Change Limit1461621277.36019859.0
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.81222873.9
 
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.