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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

66 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
beflecks194375(None) 
befleck1843941befleck_
bedecks1635792be_decks
befleas1236972befle_as
beflecked2142652beflecked
belleeks1444362belleeks
deflects14336732deflects
flecks154310802__flecks
reflects13288872reflects
becks135522013b___ecks
becloaks1644933becloaks
bedeck1536213be_deck_
bedless1039703bedle_ss
bedrocks1745333bedrocks
bedticks1774163bedticks
beefless1335493beefle_ss
beflags1355493befl_ags
beflea1147123befle__a
befleaed1454663befleaed
beflecking2243033beflecking
befrets1237613befre_ts
beleaps1138053be_leaps
belleek1347243belleek_
belles85325993belle__s
bemocks1735373be_mocks
berserks1433993berserks
bespeaks1643963bespeaks
beylics1436183beylic_s
beyliks1634853beyl_iks
blacks144914953b__lacks
bleaks125112433b__leaks
blocks144513943b__locks
bollocks1636503bollocks
bullnecks1742273bullnecks
bullocks1636293bullocks
burlesks1443223burlesks
defects134511523def_ects
defleas1147223defle_as
deflect13399973deflec_t
defrocks1844113defrocks
effects1535283_effects
elects83315003_e_lects
elflocks1742743elflocks
fecks145417853__f_ecks
fetlocks1744713fetlocks
flacks154114533__flacks
fleck148213593__fleck_
flecky18387653__flecky
flicks154512993__flicks
flocks154713533__flocks
hemlocks1944993hemlocks
henpecks1942873henpecks
inflects1336203inflects
neglects1144383neglects
rebecks15288013re_becks
rechecks1944553rechecks
rednecks1544013rednecks
reelects103110883reelects
refects124012743ref_ects
reflect123913713reflec_t
reflets103513153refle_ts
reflexes1865933reflexes
relocks134411293re_locks
selects91912143se_lects
wedlocks1844393wedlocks
zebecks24274193ze_becks

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.436409841.7
2DLD Change Limit146162667.42019698.4
3Display Results66660.0332000.0
 (SQL Overall)178691667.88922650.7
 
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.