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 “bawls” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

186 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
bawls10571932(None) 
awls75926091_awls
baals76122701baals
bails75933521bails
balls76236411balls
bals66354041ba_ls
bawds116115491bawds
bawl95326061bawl_
bowls106121431bowls
brawls115214331brawls
pawls105617661pawls
wawls115416471wawls
yawls114613601yawls
aals49941142_aals
ails45654712_ails
alls46740922_alls
als36663022_a_ls
awes76037552_awes
awl67635302_awl_
awns75324432_awns
awols84713522_awols
baal67033112baal_
baas66844672ba_as
babas96325732babas
babels105216722babels
babes95834112babes
babuls105413642babuls
babus95620332babus
backs135729622backs
badly114918762badly
bads77048862ba_ds
baffs134718052baffs
bagels95712312bagels
bags76645502ba_gs
bahts105617802bahts
bail65042802bail_
baits76630582baits
bakes117035372bakes
bal56662722ba_l_
balas76937212balas
bald76432902ba_ld
balds85524642balds
bale66353842ba_le
bales76250082bales
balk105132222ba_lk
balks114926292balks
ball66043322ba_ll
ballsy11508872ballsy
bally105530102bally
balm85534202ba_lm
balms95723922balms
balsa77920412ba_lsa
bams87044452ba_ms
bands85233422bands
banes74945582banes
bangs85627772bangs
banks115527902banks
banns75321232banns
bans66555142ba_ns
baps86040842ba_ps
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barns76335142barns
bars66564092ba_rs
bas58681752ba__s
bases75644352bases
basils85717472basils
basis75429862basis
basks115621762basks
bass66146782ba_ss
basts75936932basts
bates75846342bates
baths105922922baths
bats66962332ba_ts
batts76727562batts
bauds85821042bauds
baulk114914332baulk
baulks12429372baulks
bawd105520842baw_d
bawdy147513282bawdy
bawled124415692bawled
bawler114315052bawler
bawlers124412732bawlers
bawty135614102bawty
bays97143912ba_ys
bells76432162bells
bels66142492b_els
bills75632862bills
birls74023162birls
blaws105620462blaw_s
boils75427192boils
bolls75531312bolls
bowels114315592bowels
bowl96827702bowl_
bows96242862bow_s
brails84621292brails
brawl106217962brawl_
brawly144312352brawly
brawns115614082brawns
braws106425192braw_s
buhls105111802buhls
bulls75629572bulls
burls74228852burls
byrls105711232byrls
calls75634732calls
carls77037422carls
cauls75727772cauls
caws96036112caw_s
cowls106922212cowls
crawls114712082crawls
dahls95012282dahls
dals57145122da_ls
dawks135213492dawks
dawns95916592dawns
daws86638242daw_s
dawts97216122dawts
drawls105511392drawls
earls56127512earls
fails85631482fails
falls85727652falls
farls85731112farls
fawns115914262fawns
fowls115518892fowls
galls64729322galls
gals57946502ga_ls
gaols66717572gaols
gawks136811632gawks
gawps115911012gawps
hails85231642hails
halls85633782halls
harls85634502harls
hauls86123732hauls
hawks155415702hawks
haws106439442haw_s
howls116219222howls
jails125422942jails
jarls126120962jarls
jaws145027292jaw_s
jowls156214522jowls
kails95525212kails
lalls55324132lalls
lawns85215422lawns
laws76441682law_s
mails76037782mails
malls76233432malls
marls75535162marls
mauls76524952mauls
maws96437142maw_s
mewls105813232mewls
nails55730402nails
owls76022932_owls
pails75833062pails
palls74332562palls
pals66951352pa_ls
pawl95123262pawl_
pawns108818132pawns
paws96038182paw_s
rails55937402rails
rawly115115832rawly
raws75238212raw_s
sails55738102sails
sals46851672sa_ls
sauls55128122sauls
saws75839482saw_s
shawls125411972shawls
taels56822072taels
tails55634192tails
talls55133432talls
taws75641592taw_s
trawls94412392trawls
vails85825932vails
vaws105527322vaw_s
wails86631482wails
walls85529382walls
wauls86120552wauls
wawl105321942wawl_
waws106834902waw_s
yawl104918972yawl_
yawns114213272yawns
yawps13628792yawps
yaws105531212yaw_s
yowls115715432yowls

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538001861.42337807.4
3Display Results1861860.0632952.4
 (SQL Overall)1786911861.79699493.9
 
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.