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

57 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
berake12421608(None) 
beraked144312431beraked
berakes134815771berakes
berate84729021berate
betake124512701betake
brake116025341b_rake
aerate64830552aerate
bake105637512b__ake
beak106534382be_ak_
beaked135919492be_aked
beaker125520692be_aker
beaks115326622be_aks
beaky146118022be_aky
became123213162became
bedrape1277692bedrape
begaze1838332begaze
behave14209012behave
belike124616282belike
bename103316072bename
berated104422132berated
berates94126872berates
bereave1258352bereave
berime105317332berime
berk105929842ber_k_
berks115423122ber_ks
berme96022942ber_me
bespake15436962bespake
betaken13438282betaken
betakes134212522betakes
beware11313712beware
borage93917012borage
borane84620212borane
borate85026152borate
brace95629272b_race
brae65639112b_ra_e
braked135318692b_raked
brakes124923122b_rakes
braky145015812b_raky
brave104925502b_rave
braze165423452b_raze
break115319402break_
breaker133912922breaker
breaks124816422breaks
broke116019782b_roke
burke115122762bur_ke
cerate84829462cerate
crake114823522_crake
derate74531232derate
drake104918302_drake
erase54925492_erase
peruke123210392peruke
rake84841572__rake
remake124016112remake
retake104718532retake
rewake135218462rewake
serape84818412serape
strake104017392strake

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.360496363.9
2DLD Change Limit82551572.39034540.2
3Display Results57570.0163562.5
 (SQL Overall)178691572.76664602.7
 
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.