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

268 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
beers7562839(None) 
bears75739041bears
beefs105618561beefs
beeps95320971beeps
beer65635991beer_
beery105220121beery
bees65453381bee_s
beets76131441beets
biers76225221biers
deers64930521deers
jeers124818131jeers
leers54828981leers
peers75130271peers
seers55136381seers
veers84521361veers
agers65027852agers
ambeers11428922ambeers
ameers84015572ameers
apers76629132apers
avers85127312avers
bakers125323452bakers
balers85626932balers
bares75457132bares
bars66564092b_ars
beaders104120182beaders
beads85429502beads
beakers134216872beakers
beaks115326622beaks
beams95328172beams
beans75734692beans
bear66844642bear_
beard86024962beard
beards94116672beards
bearers94619592bearers
beaters94925042beaters
beats76042242beats
beaus75127112beaus
beavers124417322beavers
becks135522012becks
bedders113513382bedders
bedels94015272bedels
bedews12398942bedews
beds75937782b_eds
bee56262402bee__
beech124315502beech
beedi8711662beedi
beef96233682bee_f
beefy135313832beefy
been65335782bee_n
beep85931212bee_p
beepers113612382beepers
beet66457542bee_t
beeves114615042beeves
beezers18349242beezers
begets96215522begets
begs75733832b_egs
beliers94617382beliers
bells76432162bells
bels66142492b_els
belters93819412belters
belts75931162belts
bemas96424282bemas
benders104021062benders
bends85628972bends
benes75536232benes
bens65945702b_ens
bents76033692bents
beret74946362beret
berets85822522berets
berg75425542b_erg
bergs84718042bergs
berk105929842b_erk
berks115423122berks
berm86732752b_erm
berms95323662berms
berry104521772berry
bes56557432b_e_s
beses75830722beses
besets85718802besets
bests75932612bests
betas75528762betas
betels84515062betels
beths105519222beths
bets67051442b_ets
betters94422092betters
bevels113913982bevels
bevors111610342bevors
beys913829552b_eys
bezels173712282bezels
biders94822802biders
bier65531832bier_
bikers124517552bikers
biners85023632biners
birrs74917102birrs
biters83925242biters
blears85116452blears
blebs96416152blebs
bleeds95211592bleeds
bleeps10499102bleeps
bless75917812bless
blets75324942blets
blurs74619082blurs
boars75229602boars
boners84825432boners
boors74325012boors
borers85122682borers
bores76448252bores
bowers115523702bowers
boxers155013482boxers
breeds94914882breeds
breeks125310792breeks
brees75632552brees
brens75823362brens
brewers123811062brewers
brews105617072brews
briers85319732briers
buhrs104811242buhrs
burrs74925652burrs
burs65847422b_urs
buyers114511002buyers
byes95230532bye_s
byres104421382byres
ceders93817672ceders
cees65941592cee_s
ceres75540012ceres
cheers114518912cheers
dears65736882dears
deeds75423762deeds
deems85421772deems
deeps84921772deeps
deer56739022deer_
dees56356632dee_s
deets65330242deets
defers105116942defers
deters74724682deters
doers65225712doers
dyers96617132dyers
ears46356592_ears
eels46536742_eels
eery76129622_eery
egers65120372egers
emeers83314182emeers
errs45622532_errs
ers36046282__ers
ewers86018822ewers
eyers86521332eyers
fears84829392fears
feebs106112682feebs
feeds94921142feeds
feels85223042feels
fees76450602fee_s
feres86038182feres
fevers125414892fevers
fleers96015792fleers
freers94717302freers
gears64628692gears
geeks104915842geeks
gees55647882gee_s
goers65520252goers
hears86737372hears
heders104119762heders
heeds95420422heeds
heels85625532heels
heirs85618562heirs
heres86245902heres
hers75844872_hers
hewers123715272hewers
hexers165612752hexers
hoers85724922hoers
jeeps144715372jeeps
jeer115426462jeer_
jees115938542jee_s
keefs125116282keefs
keeks84717252keeks
keels94622412keels
keens95721182keens
keeps116020282keeps
keets95123482keets
keirs95313672keirs
kiers95320092kiers
lears55938732lears
leeks95318892leeks
leer46239352leer_
leery85919132leery
lees45455882lee_s
leets54927122leets
legers74518312legers
lehrs86111132lehrs
lepers84817322lepers
levers94621322levers
liers55130402liers
meeds84920272meeds
meets74224612meets
meres75143572meres
meters85625832meters
nears55529422nears
needs65719632needs
neems77316292neems
neeps75617882neeps
obeyers1234812obeyers
omers76923192omers
overs85224792overs
oyers87620882oyers
pears75138612pears
peeks115021112peeks
peels75226422peels
peens76428192peens
peeps95822362peeps
peer66238352peer_
peery105719442peery
pees65257372pee_s
peres76246642peres
peters86624592peters
piers75926332piers
queers153510772queers
rears54739652rears
reeds65430902reeds
reefs85121662reefs
reeks94124032reeks
reels55333262reels
rees45364192ree_s
refers93921082refers
revers94529632revers
ruers515019412ruers
sears54744912sears
seders74420282seders
seeds64330062seeds
seeks94724642seeks
seels55632822seels
seems75525022seems
seeps74828752seeps
seer45547042seer_
sees45361052see_s
seres55448892seres
sers45746652_sers
severs94121122severs
sewers94719722sewers
sheers94322402sheers
sneers64016172sneers
speers85019952speers
steers63820982steers
suers55128482suers
tears55436462tears
teels55726372teels
teems76019782teems
teens56227482teens
tees45353582tee_s
tiers55526522tiers
tyers86220052tyers
users55817572users
veeps104715722veeps
veer76229572veer_
veery115816252veery
vees75439432vee_s
vexers165210402vexers
viers85621952viers
wears86030302wears
webers11310942webers
weeds95222212weeds
weeks125017862weeks
weens85224052weens
weeps104120562weeps
weer75535092weer_
wees76249122wee_s
weets85427722weets
weirs84316492weirs
years84527672years
zees136331892zee_s

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.373479064.3
2DLD Change Limit538002681.48336277.8
3Display Results2682680.0803350.0
 (SQL Overall)1786912681.93692299.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.