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

296 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
byways173467(None) 
byway1647531byway_
always12409132always
anyways1644422anyways
bays97143912b__ays
belays114313852belays
bewrays15145112bewrays
brays106723112b_rays
bylaws14415832bylaws
bypass1345042bypass
byplays1743102byplays
flyways19133852flyways
keyways2043372keyways
noways12127732noways
skyways2043222skyways
sways115518462_sways
ways107737952__ways
yays105728912_y_ays
airways1336243airways
allays94313743allays
alway116113923alway_
anyway1534803anyway_
arrays95311683arrays
assays977903assays
away108024223_away_
ayahs116813523ay_ahs
ays67050293___ays
baals76122703b_aals
baas66844673b__aas
babas96325733baba_s
badass949293badass
bads77048863b__ads
bagass938933bagass
bags76645503b__ags
balas76937213bala_s
bals66354043b__als
bams87044453b__ams
bans66555133b__ans
baps86040843b__aps
bars66564093b__ars
bas58681753b__a_s
bass66146783b__ass
bats66962333b__ats
bawds116115493baw_ds
bawdy147513283bawdy_
bawls105719323baw_ls
bawty135614103bawty_
bay89661643b__ay_
bazars174613113bazars
beads85429503b_eads
beaks115326623b_eaks
beams95328173b_eams
beans75734693b_eans
bears75739043b_ears
beats76042243b_eats
beaus75127113b_eaus
becaps123811403becaps
belay105021523belay_
beltways1683903beltways
bemas96424283bema_s
bendays13327513bendays
bendways1743733bendways
bendys12518383bendys
betas75528763beta_s
betrays12127823betrays
bewail1189583bewail
bewails1277553bewails
beware11313713beware
bewares12313373bewares
bewigs1246533bewigs
bewraps14135403bewraps
bewray14147733bewray_
beys913829553b__eys
bialys11387913bialys
bias64738163b_ia_s
bikeways2043653bikeways
bimahs13508303bimahs
bimas95521743bima_s
blabs95619633b_labs
blahs105616513b_lahs
blams95023853b_lams
blats75132503b_lats
blaws105620463b_laws
bleaks125112433bleaks
blears85116453blears
bleats85518613bleats
bloats85215763bloats
blowbys17353813blowbys
blueys11419523blueys
boars75229603b_oars
boas66150833b_oa_s
boats75635153b_oats
bogans95714813bogans
bogeys124510913bogeys
bolas74733763bola_s
borals86721913borals
boras75938303bora_s
botas75328783bota_s
bowels114315593bowels
bowers115523703bowers
bowls106121433bow_ls
bows96242863bow__s
bowses115718863bowses
boyars115611983boyars
boylas113011723boyla_s
boys96737333b__oys
brads85528293b_rads
braes75735053b_raes
brags85625103b_rags
brans75437433b_rans
bras65746453b_ra_s
brass75428023b_rass
brats75336013b_rats
brawls115214333brawls
brawns115614083brawns
braws106425193b_raws
bray95232903b_ray_
breads95419203breads
breaks124816423breaks
breams104815043breams
briars84814823briars
broads94515143broads
bubals103513843bubals
bunas75126573buna_s
bunyas11359433bunyas
buoys104810633b_uoys
burans85019303burans
buras74736293bura_s
buys95726793b__uys
bwana10310243b_wana
bwanas1157443b_wanas
byelaws1533263byelaws
byes95230533by__es
bylaw13408603byla_w
byname13256363byname
bynames14256243bynames
bypast13117373bypast
bypath1645353bypath
bypaths1743193bypaths
byplay1634193byplay_
byres104421383by_res
byrls105711233by_rls
byroads1335293byroads
bys85229463b___ys
byssus1133763byssus
bytalk1533473bytalk
bytalks1632713bytalks
bytes105217493by_tes
byword1535053byword
bywords1634283bywords
bywork1834863bywork
byworks1944543byworks
byzant2096813byzant
byzants2153223byzants
cays95437673__cays
chays135319743_chays
clays105521333_clays
cogways1634633cogways
copays134911273copays
cyans105714813cy_ans
cycads14476213cycads
cycas126513823cyca_s
cymars13599143cymars
cymas126417883cyma_s
days87637133__days
decays124612913decays
delays104014053delays
derays105514253derays
dewans105215143dewans
dewars105117073dewars
diwans105110373diwans
drays95819773_drays
dyads10549973dy_ads
embays131408333embays
endways1444443endways
essays965653essays
eyas76427433ey_a_s
eyass84410783ey_ass
eyras84715923eyra_s
fays108535363__fays
flays116321053_flays
flyaways2042813flyaways
flyway18134693flyway_
forays124813003forays
frays116920103_frays
gamays126310903gamays
gays87338023__gays
gowans105512293gowans
grays95621333_grays
hays106138073__hays
heydays1734143heydays
hylas114815903hyla_s
inlays9389873inlays
jawans1657843jawans
jays146328343__jays
jetways2094053jetways
jowars16369653jowars
kays116032193__kays
keyway1943823keyway_
kyaks11459163ky_aks
kyars124813963ky_ars
kyats125012443ky_ats
layaways1743403layaways
lays76043253__lays
leeways1354453leeways
logways1434513logways
maydays1634483maydays
mays96940023__mays
midways16386183midways
morays114613883morays
mylars114310443mylars
mynahs14416443mynahs
mynas105815233myna_s
nawabs1185063nawabs
nays75931593__nays
naysays1344123naysays
noway111112843noway_
ofays11488923_ofays
oilways1334873oilways
okays12609443_okays
onlays9398713onlays
paydays1634433paydays
pays95940223__pays
plays106320773_plays
prays105022433_prays
psywars1533673psywars
pyas96225703py_a_s
pyrans11411063pyrans
quays174612043_quays
rays77642353__rays
relays94316753relays
repays113813973repays
resays93714153resays
rowans95715343rowans
runways13134443runways
ryas77224613ry_a_s
satays94411683satays
says75942103__says
seaways13307513seaways
sewans95215903sewans
sewars94018623sewars
shays116021433_shays
shwas116415103shwa_s
skyway1933343skyway_
slays85723683_slays
sowans94215893sowans
sowars94318003sowars
spays105520513_spays
splays114910873splays
sprays115913643sprays
stays86022023_stays
strays96417933strays
subways1536163subways
swabs105817273_swabs
swags94921253_swags
swans84625013_swans
swaps104819203_swaps
swats85726863_swats
sway107128233_sway_
todays10458103todays
tokays13397773tokays
trays85623433_trays
twaes86513663_twaes
twas76824083_twa_s
twats86616603_twats
unlays93810493unlays
unsays9399543unsays
wabs97337233__wabs
wads87343143__wads
waes76048603__waes
wags86140553__wags
wans76452263__wans
waps96642083__waps
wars78659803__wars
was68767563__wa_s
wats77555883__wats
waws106834903__waws
way96757663__way_
waylays1634673waylays
whys137011663__whys
xylans1635883xylans
yags86632293_y_ags
yaks116025203_y_aks
yams95330733_y_ams
yaps95933523_y_aps
yawls114613603_yawls
yawns114213273_yawns
yawps13628793_yawps
yaws105531213_y_aws
yay96948713_y_ay_
yeahs115214553_yeahs
yeans86624883_yeans
years84527673_years
yeas78638423_yea_s
yuans84613323_yuans
ywis105313103_yw_is

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.1401276364.3
2DLD Change Limit1127162965.89019136.8
3Display Results2962960.0933182.8
 (SQL Overall)1786912966.12329183.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.