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

187 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
bewrays1514511(None) 
betrays12127821betrays
bewraps14135401bewraps
bewray14147731bewray_
belays114313852be_lays
bendays13327512bendays
betray111511442betray_
bewares12313372bewares
bewrap13157052bewra_p
bewrapt14147132bewrapt
bewrayed1733932bewrayed
bewrayer1643732bewrayer
bewrayers1743482bewrayers
brays106723112b__rays
byways1734672byw_ays
defrays1436112defrays
derays105514252de_rays
rewraps12136562rewraps
affrays1644063affrays
airways1336243airways
always12409133alw_ays
arrays95311683_arrays
bays97143913b___ays
beads85429503be__ads
beaks115326623be__aks
beams95328173be__ams
beans75734693be__ans
bearcats1267023bearcats
beards94116673bear_ds
bearers94619593bearers
bears75739043be__ars
beats76042243be__ats
beaus75127113be__aus
becaps123811403be_caps
becrawl1444583becrawl
becrawls1543623becrawls
bedlams1237053bedlams
bedpans1237173bedpans
bedrail1037253bedrail
bedrails1136293bedrails
bedrape1277693bedrape
bedrapes1386963bedrapes
bedrugs11194283bedrugs
bedwards1596393bedwards
bedwarfs17113583bedwarfs
beers75628393beer__s
beery105220123beer_y_
beflags1355493beflags
befrets1237613befrets
beggars11378223beggars
beglads11127263beglads
begrims1276763begrims
begroans1145503begroans
beheads1338523beheads
belay105021523be_lay_
beldams1237053beldams
beleaps1138053beleaps
belgas9311713belga_s
beltways1683903beltways
bemas96424283be_ma_s
bemeans1148733bemeans
bemoans1138253bemoans
benday123810813benday_
bendways1743733bendways
bendys12518383be_ndys
berake124216083be_rake
berakes134815773be_rakes
berate84729023be_rate
berates94126873be_rates
berets85822523be_rets
bergs84718043be_r_gs
berks115423123be_r_ks
bermes106023003be_rmes
berms95323663be_r_ms
berries94423553berries
berry104521773be_rry_
berths114712423be_rths
beryl101211673be_r_yl
beryls11107883be_ryls
beswarms1544323beswarms
betas75528763be_ta_s
betrayal1343593betrayal
betrayals1442963betrayals
betrayed1436303betrayed
betrayer1345643betrayer
betrayers1445013betrayers
bettas84913923betta_s
bewail1189583bew_ail
bewails1277553bewails
beware11313713bew_are
bewared13310113bewared
beweary1536223beweary
beweeps1494563beweeps
bewigs1246533bew_igs
beworms1437933beworms
beworry1543743beworry_
bewraying1834873bewraying
beys913829553be___ys
bezoars1836793bezoars
bharals1236733bharals
bikeways2043653bikew_ays
borals86721913b_orals
boras75938303b_ora_s
brads85528293b__rads
braes75735053b__raes
brags85625103b__rags
brans75437433b__rans
bras65746453b__ra_s
brass75428023b__rass
brats75336013b__rats
braws106425193b__raws
bray95232903b__ray_
burans85019303b_urans
buras74736303b_ura_s
byplays1743103byplays
byway1647533byw_ay_
decays124612913de_cays
deejays1843433deejays
defrags1236193defrags
defray1337643defray_
delays104014053de_lays
derats74625063de_rats
deray95024183de_ray_
dewans105215143dew_ans
dewars105117073dew_ars
dewlaps1334663dewlaps
drays95819773__drays
embays131408333_embays
enwraps1284833enwraps
eras45441503_e_ra_s
essays965653_essays
estrays10529403estrays
eyras84715923_eyra_s
ferals94216643fe_rals
forays124813003_forays
frays116920103__frays
gerahs1039413ge_rahs
gewgaws1541643gewgaws
grays95621333__grays
hearsays1444513hearsays
henrys12366103henr_ys
heydays1734143heydays
hoorays13418373hoorays
hurrays13386153hurrays
inwraps12105253inwraps
jetways2094053jetways
keyways2043373keyways
leeways1354453leeways
morays114613883_morays
noways12127733now_ays
orfrays1343533orfrays
prays105022433__prays
prewraps15114053prewraps
qwertys224973qwertys
rays77642353___rays
redbays1336013redbays
redraws11218473redraws
relays94316753re_lays
repays113813973re_pays
replays12399763replays
resays93714153re_says
resprays1344713resprays
rewards114813993rewards
rewarms12439603rewarms
rewears102911043rewears
rewrap11127533rewra_p
rewrapt12138113rewrapt
seaways13307513seaways
seracs84418573se_racs
serais64326133se_rais
sewans95215903sew_ans
sewars94018633sew_ars
sprays115913643_sprays
strays96417933_strays
sunrays1037083sunrays
sways115518463_sw_ays
terais64023513te_rais
terras63516973terra_s
tetrads82910193tetrads
tetras63017623tetra_s
trays85623433__trays
unwraps1255513unwraps
veejays2042313veejays
ways107737953__w_ays
wraps105617153__wraps
zebras1737853zebra_s
zebrass1834113zebrass

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271876.42320866.7
3Display Results1871870.0762460.5
 (SQL Overall)1786911876.90525878.5
 
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.