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

63 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
bewrayers174348(None) 
betrayers1445011betrayers
bewrayer1643731bewrayer_
belayers13298142be_layers
betrayer1345642betrayer_
bewrayed1733932bewraye_d
bewrays15145112bewray__s
brayers124511902b__rayers
defrayers1644172defrayers
affrayers1842213affrayers
arrayers11125853_arrayers
barraters1138043barraters
beaders104120183be__aders
beakers134216873be__akers
bearers94619593be__arers
beaters94925043be__aters
beavers124417323be__avers
bediapers1444333bediapers
bedmakers1844383bedmakers
bedrapes1386963bedrape_s
bedwarmers1842703bedwarmers
behavers16205613be_havers
beheaders1545153beheaders
bejabers1933633be_jabers
belayer12339503be_layer_
berakes134815773be_rake_s
berates94126873be_rate_s
bereavers1446123bereavers
betrayals1442963betrayals
betrayed1436303betraye_d
betrays12127823betray__s
bewailers1434233bewailers
bewares12313373bew_are_s
bewilders1543813bewilders
bewraps14135403bewra__ps
bewray14147733bewray___
bewraying1834873bewraying
bilayers13296923b_ilayers
bowyers15438733bow__yers
bracers114616703b__racers
bravers124715523b__ravers
brayer115315313b__rayer_
brazers184513943b__razers
decayers14307963de_cayers
defrayer1534933defrayer_
degraders12245933degraders
delayers12268663de_layers
depravers1534683depravers
dewaters122910723dew_aters
erasers74413943_e_rasers
essayers1133563_essayers
forayers14277273_forayers
newwavers1841873newwavers
prayers124212853__prayers
redrawers1344353redrawers
retracers11149553retracers
rewarders13226453rewarders
rewriters1236343rewriters
sprayers13367053_sprayers
strayers113510143_strayers
swayers13398853_sw_ayers
tetramers1146463tetramers
yeasayers1542023yeasayers

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 Filter1786911486410.440406115.9
2DLD Change Limit148641636.36023371.2
3Display Results63630.0302100.0
 (SQL Overall)178691636.83026162.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.