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

152 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
byelaw144425(None) 
byelaws1533261byelaws
bylaw13408601by_law
belay105021522b_elay
below104617192b_elow
blaw97026722b__law
bylaws14415832by_laws
byplay1634192byplay
prelaw1139102prelaw
akela9311343akela_
akelas10311193akelas
baklawa1643403baklawa
balas76937213b_alas
ballad94315323ballad
barlow112911423barlow
bashaw14349303bashaw
bead75937923b_e_ad
beak106534383b_e_ak
beam86939233b_e_am
bean66443863b_e_an
bear66844643b_e_ar
beat66168303b_e_at
beau66137273b_e_au
becap114315053b_ecap
bedew114513043b_edew
bedlam1149273bedlam
beflag1265883beflag
began86319573b_egan
begat86629723b_egat
beglad10138463beglad
bel57148463b_el__
belady12489933b_elady
belaud939133b_elaud
belays114313853b_elays
belch124415503b_elch
beldam11410113b_eldam
beleap10410283b_eleap
belga8313233b_elga
belgas9311713b_elgas
belie75630383b_elie
bell66237183b_el_l
belle75827833b_elle
bellow114213353bellow
bells76432163b_ells
belly104625493b_elly
belon73924113b_elon
belows114614183b_elows
bels66142493b_el_s
belt65754033b_el_t
belts75931163b_elts
bema85825253b_ema_
bemas96424283b_emas
beta66234133b_eta_
betas75528763b_etas
beylic1337823beylic
beylik1545883beylik
bield84614653biel_d
bields94110003bields
billow114111223billow
blab86629133b__lab
blae66134643b__lae
blah98625063b__lah
blam86131703b__lam
blat66550953b__lat
blawn106813703b__lawn
blaws105620463b__laws
bleak115915383ble_ak
blear75918683ble_ar
bleat75737003ble_at
blew94722433b__lew
blow95827193b__low
bola66035563b_ola_
bolar75123473b_olar
bolas74733763b_olas
boyla102912363boyla_
boylas113011723boylas
braw94829563b__raw
bread85523113bre_ad
break115319403bre_ak
bream95121813bre_am
brew95023563bre__w
bulla74620563bulla_
bullae83416163bullae
burlap1098353burlap
bye86134593bye___
byes95230533bye__s
byplays1743103byplays
byrl95716013byrl__
byrled12437173byrled
byrls105711233byrl_s
byroad1236623byroad
byssal1134993byssal
bytalk1533473bytalk
byway1647533by_way
chela103916803chela_
chelae113614603chelae
chelas113817203chelas
claw95624343__claw
declaw1266703declaw
delay94820633_delay
elan46734243__elan
eyebar1135323eyebar
eyelash1344563eyelash
eyelet9514533eyelet
eyelid1038443eyelid
flaw106326643__flaw
geegaw1142853geegaw
heehaw1543933heehaw
hyena11810253hyena_
hyenas1288953hyenas
hyetal1236543hyetal
hyla106716513hy_la_
hylas114815903hy_las
law68656643___law
myelin1138973myelin
mylar105311533my_lar
nyala836823nyala_
nyalas936903nyalas
outlaw9279643outlaw
pilaw103913743_pilaw
relax124817803_relax
relay84424673_relay
resaw84117253_resaw
seesaw935973seesaw
selah8319613_selah
slaw77930713__slaw
stela54019043stela_
stelae63716483stelae
stelai63912563stelai
stelar64013863stelar
tela45532973_tela_
telae54323293_telae
vela75725543_vela_
velar85817633_velar
xylan1537463xy_lan
yaw97145153_y__aw
yclad11246383_yclad
yea66445753_ye_a_
yeah106725413_ye_ah
yean75834583_ye_an
year76534253_ye_ar
yeas78638423_ye_as
yeld811423873_yel_d
yelk115320003_yel_k
yelks126413623_yelks
yell76028323_yel_l
yellow12429883_yellow
yells85821943_yells
yelp95621353_yel_p
yelps105712993_yelps
yew96436293_ye__w
yulan8411493_yulan

Search took 6 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.373479064.3
2DLD Change Limit1127161524.69024033.3
3Display Results1521520.0463304.3
 (SQL Overall)1786911525.10934975.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.