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

275 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
betrays1212782(None) 
betray111511441betray_
bewrays15145111bewrays
belays114313852be_lays
beltways1683902beltways
bendays13327512bendays
betas75528762bet_a_s
betrayal1343592betrayal
betrayals1442962betrayals
betrayed1436302betrayed
betrayer1345642betrayer
betrayers1445012betrayers
bettas84913922betta_s
bewraps14135402bewraps
bewray14147732bewray_
brays106723112b__rays
defrays1436112defrays
derays105514252de_rays
estrays10529402estrays
jetways2094052jetways
strays96417932_strays
tetrads82910192tetrads
tetras63017622tetra_s
trays85623432__trays
abettals1054723abettals
affrays1644063affrays
amtracs1198883amtracs
arrays95311683_arrays
ashtrays14534203ashtrays
astrals75515243astrals
astray95615543astray_
batboys1465833batboys
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
bedstraws1542403bedstraws
beers75628393beer__s
beery105220123beer_y_
beflags1355493beflags
befrets1237613befrets
beggars11378223beggars
beglads11127263beglads
begrims1276763begrims
begroans1145503begroans
beheads1338523beheads
belay105021523be_lay_
beldams1237053beldams
beleaps1138053beleaps
belgas9311713belga_s
beltway1564373beltway_
bemas96424283be_ma_s
bemeans1148743bemeans
bemoans1138253bemoans
benday123810813benday_
bendways1743733bendways
bendys12518383be_ndys
bentgrass1242963bentgrass
berake124216083be_rake
berakes134815773be_rakes
berate84729023be_rate
berates94126873be_rates
berets85822523be_rets
bergs84718043be_r_gs
berks115423123be_r_ks
bermes106023003be_rmes
berms95323663be_r_ms
berries94423553berries
berry104521773be_rry_
berthas12398763berthas
berths114712423be_rths
beryl101211673be_r_yl
beryls11107883be_ryls
besteads11307113besteads
bestrews1335603bestrews
bestrows1337043bestrows
beta66234133bet_a__
betake124512703bet_ake
betakes134212523betakes
betels84515063bet_els
bethank1666273bethank
bethanks1765313bethanks
bethels1238533bethels
beths105519223bet__hs
betides104915263betides
betimes115114413betimes
betises94816123betises
betons84919553bet_ons
betony114211583betony_
betraying1537713betraying
betroth1247543betroth
betroths1345633betroths
bets67051443bet___s
betta74916843betta__
betters94422093betters
bettors93312473bettors
bewares12313373bewares
bewrap13157053bewra_p
bewrapt14147133bewrapt
bewrayed1733933bewrayed
bewrayer1643733bewrayer
bewrayers1743483bewrayers
beys913829553be___ys
bezoars1836793bezoars
bharals1236733bharals
bitmaps1344253bitmaps
borals86721913b_orals
boras75938303b_ora_s
botas75328783bot_a_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
buttals938503buttals
butyrals1344503butyrals
byplays1743103byplays
byways1734673b_yways
centrals102712033centrals
citrals91111673citrals
decays124612913de_cays
deejays1843433deejays
defrags1236193defrags
defray1337643defray_
delays104014053de_lays
derats74625063de_rats
deray95024183de_ray_
destroys1236693destroys
detract101414633detract
detracts11138833detracts
detrain8412253detrain
detrains9411763detrains
dextrans1695983dextrans
drays95819773__drays
embays131408333_embays
entraps9109763entraps
eras45441503_e_ra_s
essays965653_essays
estray95713333estray_
etas46432273_et_a_s
etnas54713933_etna_s
extras13310223extra_s
eyras84715923_eyra_s
ferals94216643fe_rals
fetas85624403fet_a_s
fetials103711743fetials
forays124813003_forays
frays116920103__frays
gerahs1039413ge_rahs
getas65421483get_a_s
getaways1543343getaways
grays95621333__grays
hearsays1444513hearsays
henrys12366103henr_ys
hetmans12187593hetmans
heydays1734143heydays
hoorays13418373hoorays
hurrays13386153hurrays
jetlags1533863jetlags
jetsams16124103jetsams
jetway19105273jetway_
keyways2043373keyways
leeways1354453leeways
lethals1038113lethals
matrass939403matrass
metals84520883met_als
metres85121563metr_es
metrics11312363metrics
metros84217803metr_os
morays114613883_morays
neutrals846283neutrals
orfrays1343533orfrays
osetras737323osetra_s
outlays102610903outlays
outprays13236933outprays
outsays102710403outsays
petals84719813pet_als
petards104311153petards
petnaps1145033petnaps
petrale9312623petrale
petrales10312983petrales
petrels9279373petrels
petrols92913083petrols
petrous92714423petrous
petsais938433petsais
peytrals1355493peytrals
portrays1345293portrays
prays105022433__prays
rays77642353___rays
redbays1336013redbays
redraws11218473redraws
relays94316753re_lays
repays113813973re_pays
replays12399763replays
resays93714153re_says
resprays1344713resprays
retags73414303ret_ags
retards85015003retards
reteams9339563reteams
retears72814923retears
retrace91417343retrace
retraces101417273retraces
retrack131310723retrack
retracks14149103retracks
retract91318113retract
retracts101111313retracts
retrain7615423retrain
retrains8314533retrains
retral64419743retra_l
retreads937823retreads
retreats8311413retreats
retrials8510823retrials
retries74129073retries
retrims93612373retrims
retros63820193retr_os
retry84718083retr_y_
rewraps12136563rewraps
satays94411683sat_ays
satraps95011643satraps
seaways13307513seaways
seracs84418573se_racs
serais64326133se_rais
sprays115913643_sprays
stays86022023_st_ays
straps87721783_straps
strass67117223_strass
straws98718673_straws
stray88525573_stray_
stroys95914603_stroys
sunrays1037083sunrays
sutras64818593sutra_s
terais64023513te_rais
terras63516973terra_s
tetra53417953tetra__
tetrad73612053tetra_d
tetris62816293tetr_is
tetryl935693tetr_yl
tetryls1034643tetryls
trams75327673__trams
trans54933043__trans
traps75727483__traps
trass56226473__trass
tray77632593__tray_
treys85018213__treys
troys86418613__troys
ultras6310193ultra_s
veejays2042313veejays
ventrals112910003ventrals
veterans1148853veterans
zebras1737853zebra_s
zebrass1834113zebrass
zetas145018163zet_a_s

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 Limit1340272756.40620922.1
3Display Results2752750.0932957.0
 (SQL Overall)1786912756.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.