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

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

94 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
beiges9101440(None) 
beige81515371beige_
beignes10149241beignes
badges103917362badges
baizes174315052baizes
barges94528252barges
beagles103212122beagles
bees65453382be__es
beeves114615042beeves
beget85632552be_get
begets96215522be_gets
begged115013802begged
begins94415302begins
begs75733832be_g_s
beigne9148612beigne
beignet101510962beignet
beignets11155372beignets
beigy111110582beig_y
beings94613032beings
belgas9311712belgas
belies84631052belies
belles85325992belles
bemires113212832bemires
bemixes18338652bemixes
benes75536232be_nes
bennes86019012bennes
bergs84718042berg_s
berimes115216642berimes
bermes106023002bermes
beses75830722be_ses
besides104814532besides
besieges1146002besieges
betides104915262betides
betimes115114412betimes
betises94816122betises
bevies114017302bevies
bewigs1246532bewig_s
bices95029962b_ices
bides85536772b_ides
bigos85020012b_igos
bigs76235012b_ig_s
bikes117529472b_ikes
biles75542142b_iles
bilges94915632bilges
bines76946792b_ines
binges93923122binges
bises75435622b_ises
bites75641172b_ites
bizes165923662b_izes
blites84721212blites
bogies94724312bogies
boites84322702boites
bribes105918532bribes
brides94423512brides
bridges113911332bridges
bries74942152bri_es
brigs85823222brig_s
brines85028852brines
brises84927612brises
budges104820122budges
bulges95919322bulges
deices94119372deices
deigns8389982deigns
edges75718722_edges
feigns10407752feigns
friges104116482friges
greiges937732greiges
hedges115016242hedges
henges104516452henges
kedges124812942kedges
ledges84917982ledges
leges64427282le_ges
lieges74113442lieges
merges94122482merges
neighs10387732neighs
obliges1037142obliges
peages94321842peages
peises84125042peises
reges65628782re_ges
reigns74811752reigns
reives95723042reives
remiges103015472remiges
sedges83817792sedges
seines65029902seines
seises64026712seises
seizes154317532seizes
serges74225962serges
sieges73816832sieges
veges94118862ve_ges
vegies104314272vegies
venges104015142venges
verges104320172verges
wedges114614552wedges
weighs13338872weighs

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit82551942.53032628.9
3Display Results94940.0332848.5
 (SQL Overall)178691942.67366850.4
 
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.