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

395 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
bros6563566(None) 
bios66335321bios
biros75325131biros
boos67955031boos
bos57966811b_os
bras65746451bras
brios74725721brios
bris65539611bris
bro56236601bro_
broo65129821broo
broos75126411broos
brose75227031brose
brosy106115381brosy
brow97228441brow
brows105425981brows
eros45238451eros
pros65742781pros
abos67734412abos
abris75722602abris
ados57633512ados
apos65433822apos
arbs66834732arbs
arcs67834782arcs
ares45871022ares
arfs76029962arfs
arks85936872arks
arms66137492arms
arose55832082arose
ars37670932ar_s
arts49650262arts
arvos86015662arvos
avos77227012avos
baas66844672baas
bads77048862bads
bags76645502bags
bals66354042bals
bams87044452bams
bans66555142bans
baps86040842baps
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barns76335142barns
baron78131242baron
barons85025382barons
bars66564092bars
bas58681752b_as
bass66146782bass
bats66962332bats
bays97143912bays
beds75937782beds
bees65453382bees
begs75733832begs
bels66142492bels
bens65945702bens
bergs84718042bergs
berks115423122berks
berms95323662berms
bes56557432b_es
bets67051442bets
beys913829552beys
bias64738162bias
bibs84830992bibs
bids75838452bids
bigos85020012bigos
bigs76235022bigs
bins66548252bins
bio57846082bio_
biog76122322biog
biogs85016112biogs
birds85421332birds
birks114920302birks
birls74023162birls
biro66131212biro_
birrs74917102birrs
bis56860662b_is
bits66148162bits
blob86027092blob
blobs95620032blobs
bloc85023272bloc
blocs95219652blocs
blog75723822blog
blogs85319232blogs
blot65842322blot
blots75626172blots
blow95827192blow
blows105423832blows
bo410957572b_o_
boa56954032b_oa
boas66150832boas
bob76755672b_ob
bobs86340652bobs
bod67055542b_od
bods76244712bods
bog67852412b_og
bogs75742752bogs
bohos105618252bohos
bolos75531372bolos
boo58163662b_oo
boob85932582boob
boobs96221992boobs
book106836332book
books115729712books
boom87435672boom
booms95427122booms
boon67142172boon
boons75031912boons
boor66130682boor
boors74325012boors
boost75132472boost
boot67759372boot
boots75837972boots
bop77549482b_op
bops86037982bops
bora66141632bora
boras75938302boras
bore66051332bore
bores76448252bores
bork106933822bork
borks115727702borks
born67338412born
boron76727142boron
borons85520542borons
bort65960962bort
borts76735452borts
bosh96328972b_osh
bosk105825732b_osk
boss65938342boss
bot59680402b_ot
bots66453952bots
bow87051902b_ow
bows96242862bows
box1210142342b_ox
boy87753562b_oy
boyos105418282boyos
boys96737332boys
bozos165216862bozos
bra56339462br_a
brad75234342brad
brads85528292brads
brae65639112brae
braes75735052braes
brag75229722brag
brags85625102brags
bran65740382bran
brans75437432brans
brash106221562brash
brass75428022brass
brat66055542brat
brats75336012brats
bravos114711392bravos
braw94829562braw
braws106425192braws
bray95232902bray
brays106723112brays
bred75130972bred
bree67241262bree
brees75632552brees
bren65629562bren
brens75823362brens
brew95023562brew
brews105617072brews
brie65837902brie
bries74942152bries
brig76528032brig
brigs85823222brigs
brim85629372brim
brims94721622brims
brin67038192brin
brins75533972brins
brio65432492brio
brisk115615982brisk
briss75824272briss
brit66350152brit
brits76433082brits
broad84817692broad
broads94515152broads
brock136017072brock
brocks145214152brocks
broil74918222broil
broils84114172broils
broke116019782broke
brome94421972brome
bromes104719762bromes
bromo95217202bromo
bromos104213312bromos
bronc91714342bronc
broncs101611152broncs
brood84620242brood
broods95416382broods
brook114717762brook
brooks125813882brooks
broom95022212broom
brooms104915872brooms
broses86524402broses
broth106521092broth
broths115013922broths
brown105619532brown
browns116415632browns
browse115713862browse
brr56921922br_r
brrr65312292brrr
brush105917472brush
brusk114912432brusk
brut66537962brut
bruts75922952bruts
brux136315272brux
bubs86235502bubs
buds75235172buds
bugs76035912bugs
bums85934592bums
buns66243722buns
buoy95921782buoy
buoys104810632buoys
buras74736302buras
burbs95423492burbs
burds84626062burds
burgs84924092burgs
burls74228852burls
burns74926782burns
burps94220172burps
burros85114992burros
burrs74925652burrs
burs65847422burs
bus56950972b_us
buss65134912buss
buts67247692buts
buys95726792buys
byes95230532byes
byres104421382byres
byrls105711232byrls
bys85229462b_ys
ceros74726072ceros
coos67456492coos
cors66656442cors
cos510270392_cos
cris66233432cris
croc85723732croc
crocs95722432crocs
crop87628632crop
crops96125242crops
cross75124502cross
crow96428132crow
crows105727312crows
crus65828482crus
dobros93910232dobros
dors56747602dors
dos48062312_dos
drop75324402drop
drops85719502drops
dross65418092dross
drys86314802drys
duos56728132duos
duros65422692duros
egos55821652egos
epos66723732epos
eras45441502eras
ergs55523812ergs
erns45428232erns
erose55727282erose
errs45622532errs
ers36046282er_s
euros54920242euros
faros85532022faros
fro65530642fro_
froe75329992froe
froes86126692froes
frog85624362frog
frogs96220772frogs
from96923922from
frons86124042frons
frosh115713402frosh
frost84727832frost
frow106425052frow
frows116623102frows
giros65722652giros
goos57644912goos
gos47155132_gos
grog65923342grog
grogs76319412grogs
grok95819682grok
groks105716122groks
gross65421692gross
grosz154814092grosz
grot55942052grot
grots65025852grots
grow86127302grow
grows95523922grows
gyros95616482gyros
heros84930862heros
hos68364192_hos
ires45639282ires
iris45732552iris
irks86220132irks
iron46728462iron
irons55324132irons
kors85933012kors
kos76944822_kos
kris86423602kris
loos49051122loos
mhos95517772mhos
moos66051302moos
mors65950062mors
mos57067122_mos
naos47429732naos
nos38859322_nos
onos46229002onos
orbs66626252orbs
orcs67025432orcs
ordos65216202ordos
ores46056682ores
ors35750112or_s
orts46538332orts
orzos143311252orzos
os211359882__os
poos65949112poos
praos74923562praos
pro55837262pro_
proa66229962proa
proas75028802proas
prod76129502prod
prods85523552prods
prof96134662prof
profs105120892profs
prog75729002prog
progs86624152progs
prom87631702prom
proms95426412proms
prop85932812prop
props95726882props
prose75835122prose
proso77222412proso
pross76529402pross
prost75434102prost
prosy106319252prosy
prow97030382prow
prows106327012prows
pyros105718292pyros
ras37575392_ras
res35565042_res
rhos76319062rhos
rob56754302_rob
robs65837872_robs
roc520243252_roc
rocs65533662_rocs
rod47953892_rod
rods56442062_rods
roe36861082_roe
roes45954142_roes
rom59855632_rom
roms67038962_roms
rose46148902_rose
rosy76024872_rosy
rot37282952_rot
rots46454092_rots
row67453672_row
rows75941752_rows
saros55238062saros
sos37761602_sos
sris45434152sris
taos45541002taos
taros55640822taros
tiros54524892tiros
toros54336192toros
tors46157382tors
tres46542902tres
trios55528092trios
trod57627952trod
trog57628212trog
trogs67022602trogs
trois57226092trois
trop66833302trop
trot46351312trot
trots56629942trots
trow78031422trow
trows88826182trows
troy77429682troy
troys86418612troys
twos76718022twos
tyros85118592tyros
udos56619902udos
urbs65922062urbs
urds55922432urds
urns46323902urns
urps66920482urps
urus46426142urus
vrow105817472vrow
vrows116115262vrows
woos76238802woos
wos66953532_wos
zeros144918112zeros
zoos135828802zoos

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 Filter178691298720.280638182.1
2DLD Change Limit298723950.76638997.4
3Display Results3953950.0934247.3
 (SQL Overall)1786913951.139156884.1
 
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.