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

309 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
bewray1414773(None) 
betray111511441betray
bewrap13157051bewrap
bewrays15145111bewrays
beery105220122beer_y
belay105021522be_lay
benday123810812benday
berry104521772be_rry
betrays12127822betrays
beware11313712beware
beweary1536222beweary
beworry1543742beworry
bewraps14135402bewraps
bewrapt14147132bewrapt
bewrayed1733932bewrayed
bewrayer1643732bewrayer
bray95232902b__ray
byway1647532byw_ay
defray1337642defray
deray95024182de_ray
rewrap11127532rewrap
aery77231683ae_r_y
affray1534973affray
airway1237693airway
alway116113923alw_ay
array86317143_array
astray95615543astray
away108024223_aw_ay
aweary1237303aweary
awry107619683_awr_y
barky145721613b_arky
barmy125218763b_army
barny105821733b_arny
bawdry15516463bawdry
bawdy147513283baw_dy
bawty135614103baw_ty
bay89661643b___ay
beachy164011253beachy
bead75937923be__ad
beady114719923be_ady
beak106534383be__ak
beaky146118023be_aky
beam86939233be__am
beamy126218573be_amy
bean66443863be__an
bear66844643be__ar
bearably15177933bearably
bearcat11611913bearcat
beard86024963bear_d
beards94116673beards
bearer85323913bearer
bears75739043bear_s
beat66168303be__at
beau66137273be__au
beauty115410163beauty
becap114315053be_cap
becrawl1444583becrawl
bedirty1344183bedirty
bedlam1149273bedlam
bedpan1137583bedpan
bedrail1037253bedrail
bedrape1277693bedrape
bedrid1039943bedrid
bedrug10164953bedrug
bedward1497473bedward
bedwarf16106463bedwarf
beechy16397503beechy
beefy135313833be_efy
beer65635993beer__
beers75628393beer_s
beflag1265883beflag
befret11315963befret
began86319573be_gan
begat86629723be_gat
beggar10328223beggar
beggary14316153beggary
beglad10138463beglad
begorah1355593begorah
begrim11118333begrim
begroan1036103begroan
behead1239923behead
beigy111110583be_igy
belady12489933belady
belays114313853be_lays
beldam11410113beldam
beleap10410283beleap
belfry1435073belfry
belga8313233belga_
belgas9311713belgas
belly104625493be_lly
beltway1564373beltway
bema85825253be_ma_
bemas96424283be_mas
bemean10410683bemean
bemoan10310253bemoan
bendays13327513bendays
bendy115017253be_ndy
benny105217363be_nny
benzal1739643benzal
berake124216083be_rake
berate84729023be_rate
beret74946363be_ret
berg75425543be_r_g
bergs84718043be_rgs
berk105929843be_r_k
berks115423123be_rks
berm86732753be_r_m
berme96022943be_rme
berms95323663be_rms
berth104917883be_rth
beryl101211673be_ryl
beswarm1445773beswarm
beta66234133be_ta_
betas75528763be_tas
betony114211583betony
betrayal1343593betrayal
betrayed1436303betrayed
betrayer1345643betrayer
betta74916843betta_
bettas84913923bettas
bevy127115223be__vy
bewail1189583bewail
bewared13310113bewared
bewares12313373bewares
beweep13147253beweep
bewept13410323bewept
bewig1138903bew_ig
bewigs1246533bewigs
beworm1339983beworm
beworms1437923beworms
bewrayers1743483bewrayers
bewraying1834873bewraying
bey86645423be___y
bezoar1736913bezoar
bharal1138893bharal
bikeway1944313bikew_ay
binary11312223binary
bleary115112553blear_y
blurry11437673blurry
bora66141633b_ora_
boral75831703b_oral
boras75938303b_oras
borax145918723b_orax
borty105522833b_orty
bowery146012113bowery
bowman13129853bowman
bra56339463b__ra_
brad75234343b__rad
brae65639113b__rae
brag75229723b__rag
braky145015813b__raky
bran65740383b__ran
bras65746453b__ras
brat66055543b__rat
braw94829563b__raw
braxy175410893b__raxy
brays106723113b__rays
brewery15376953brewery
briary114912003briary
bura66139533b_ura_
buran75225303b_uran
buras74736293b_uras
burly104922833b_urly
burry105221563b_urry
bury95633593b_ur_y
byplay1634193byplay
byways1734673byw_ays
cedary12419603cedary
cowry135512483cowr_y
dearly104615323dearly
deary95826843dear_y
decay114718483de_cay
decry115514353decr_y
deejay1734523deejay
defrag1136463defrag
defrays1436113defrays
delay94820633de_lay
denary105316863denary
derat65044083de_rat
derays105514253de_rays
derby114715343de_rby
derry94721373de_rry
dewan95718043dew_an
dewar95817733dew_ar
dewars105117073dewars
dewax165510853dew_ax
dewily1338343dewily
dewlap1264843dewlap
dewy115419023dew__y
dowry126312483dowr_y
dray85428093__dray
early85324123_early
eery76129623_eer_y
embay123410603_embay
enwrap1185213enwrap
era35741503_e_ra_
eras45441503_e_ras
essay867623_essay
estray95713333estray
eyra76217553_eyra_
eyras84715923_eyras
eyry106315883_eyr_y
feral85424653fe_ral
ferly115517353fe_rly
ferny115816183fe_rny
ferry116020803fe_rry
foray115023973_foray
fray105428903__fray
gerah9315303ge_rah
germy115113663ge_rmy
gewgaw1441783gewgaw
gray85329893__gray
hearsay1335523hearsay
hearty126313633hearty
henry114014473henr_y
herby134715313he_rby
herry114922473he_rry
heyday1635143heyday
hooray123011373hooray
hurray12459913hurray
inwrap11115903inwrap
jerky196712423je_rky
jerry155016183je_rry
jetway19105273jetway
kerry124916093ke_rry
keyway1943823keyway
leary85927383lear_y
leery85919133leer_y
leeway1255883leeway
lewdly1334393lewdly
mercy125916183me_rcy
merry104721483me_rry
moray105423793_moray
nearby11356053nearby
nearly94813733nearly
nerdy95014703ne_rdy
nervy114610863ne_rvy
neural6311993neural
newly114610203new_ly
newsy11489393new_sy
noway111112843now_ay
orfray1234393orfray
pearly116414843pearly
peery105719443peer_y
perdy115417323pe_rdy
perky145319483pe_rky
perry105222713pe_rry
pray96331533__pray
prewrap14104973prewrap
qwerty2133583qwerty
ray66361993___ray
redbay1238333redbay
redraw10269853redraw
redry94314363redr_y
refry114412463refr_y
relay84424673re_lay
repay104818453re_pay
replay113412923replay
reran57329103re_ran
resay85320543re_say
respray1236503respray
retral64419743retral
retry84718083retr_y
rewan85623663rew_an
reward106017633reward
rewarm115913483rewarm
rewax155713923rew_ax
rewear93011993rewear
rewraps12136563rewraps
rewrapt12138113rewrapt
seaway12309993seaway
senary93716073senary
sera46141393se_ra_
serac75925203se_rac
serai56830163se_rai
seral56336383se_ral
serry84824123se_rry
sewan85921293sew_an
sewar85421093sew_ar
sewars94018623sewars
spray106720063_spray
stray88525573_stray
sunray9310123sunray
sway107128233_sw_ay
teary85124053tear_y
terai53525483te_rai
terra54419663terra_
terrae62915213terrae
terras63516973terras
terry84721873te_rry
tetra53417953tetra_
tetrad73612053tetrad
tetras63017623tetras
tray77632593__tray
unwary1239823unwary
unwrap11126323unwrap
veejay1933703veejay
veery115816253veer_y
vera76828843ve_ra_
very108025643ve_r_y
wary106740013__wary
way96757663__w_ay
weary115620613wear_y
weirdy13395463weirdy
wrap96821973__wrap
wry96524703__wr_y
yearly125210273yearly
zebra1637883zebra_
zebras1737853zebras

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 Filter1786911127160.1261418182.5
2DLD Change Limit1127163095.92019039.9
3Display Results3093090.0803862.5
 (SQL Overall)1786913096.12629169.3
 
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.