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

309 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
baser7482892(None) 
abaser86414341abaser
baker115629541baker
baler75635271baler
barer74535801barer
base64847021base_
based85331581based
bases75644351bases
basher115123811basher
baster85333591baster
laser54633321laser
maser75029971maser
raser55633411raser
abase76023482abase_
abased96514992abased
abasers95311972abasers
abases85720772abases
abater85518122abater
abler75624312abler
abuser85413682abuser
ager55935842_ager
aper66336232_aper
asea46327182_asea
asker96418782_asker
asper75520432_asper
aster55434892_aster
aver75931882_aver
baaed85218162baaed
baases85218012baases
babe86835822babe_
babel95821692babel
babes95834112babes
babier103515572babier
backer144525522backer
badder103817512badder
bade75140882bade_
badger105415082badger
bagel85116792bagel
bagger104619202bagger
bailer85425252bailer
baiter84422552baiter
bake105637512bake_
baked126130772baked
bakers125323452bakers
bakery155911002bakery
bakes117035372bakes
balder95318862balder
bale66353842bale_
baled85436442baled
balers85626932balers
bales76250082bales
balker124519162balker
baller83825202baller
bander93928222bander
bane65250432bane_
baned85436352baned
banes74945582banes
banger94423632banger
banker124222732banker
banner84421502banner
banter84825332banter
bar58070552ba__r
barber104419322barber
bare65460522bare_
bared85144482bared
bares75457132bares
barker124822862barker
barre75929542barre
barter85525372barter
bas58681752bas__
basal75722282basal
basely114412312basely
basest84720492basest
bash915240162bas_h
bashed126225702bashed
bashers124820832bashers
bashes115631392bashes
basic96220522basic
basil75122272basil
basin75026922basin
basis75429862basis
bask105131422bas_k
basked135218602basked
basket125722912basket
basks115621762basks
bass66146782bas_s
basses85428302basses
basset85225382basset
bassi77019322bassi
basso76017282basso
bassy1012917102bassy
bast66362412bas_t
baste74829982baste
basted95227232basted
basters94930302basters
bastes85330382bastes
basts75936932basts
bate66552422bate_
bated85935532bated
bates75846342bates
bather115322512bather
batter84928872batter
bawler114315052bawler
bayed115423022bayed
bazar163816002bazar
beader94623792beader
beaker125520692beaker
bearer85323912bearer
beater84729392beater
beaver114819252beaver
beer65635992b_eer
beses75830722beses
beset76739132beset
biased94012222biased
biases84618432biases
bider85728372bider
bier65531832b_ier
biker116022562biker
biner75930692biner
bise66437102bise_
bises75435622bises
bister84922762bister
biter75030032biter
blader93618582blader
blamer104417142blamer
blase75524232blase_
blaster94017302blaster
blazer174414022blazer
bluer74918492bluer
boaster94616432boaster
boater84622092boater
boner75133082boner
borer75131272borer
bosker123813652bosker
bower107328182bower
boxer145016522boxer
bracer104620582bracer
brasher124515242brasher
brasier94516752brasier
braver114719042braver
brawer114216332brawer
brayer115315312brayer
brazer174917532brazer
brier74527402brier
bused85624492bused
buses75936012buses
busher114922202busher
busier85219722busier
busker125517832busker
buster84726492buster
buyer105013092buyer
caber95126832caber
cager85229222cager
caner75334772caner
caper94831622caper
carer74942332carer
case65848082case_
cased86032412cased
casern84713312casern
cases75048382cases
caster85232572caster
cater74840722cater
causer84117782causer
caver105629062caver
chaser114918382chaser
darer65230792darer
dasher104318982dasher
dater65332312dater
debaser103510412debaser
doser66228562doser
eager65526972eager
ease45042332ease_
eased65430402eased
easel54521112easel
eases56041612eases
easier64218462easier
easter65027982easter
eater54639842eater
eraser64216332eraser
facer105525052facer
fader94421512fader
faker124824592faker
falser93912412falser
farer86733142farer
faster94625772faster
gager74726292gager
gamer84928942gamer
gaper86125122gaper
gases65633992gases
gasher104320372gasher
gasper94515542gasper
gasser75017772gasser
gaster75027352gaster
gater64533652gater
gayer94519192gayer
gazer155720072gazer
haler85033522haler
hater85034752hater
haver115124462haver
hawser125910842hawser
hayer114620242hayer
hazer174820232hazer
hoser811529762hoser
jager134318132jager
japer146218882japer
jasper154610382jasper
kaiser103610372kaiser
kasher134915032kasher
lacer75833752lacer
lader65633722lader
lager65132862lager
laker95432872laker
lamer75233702lamer
lapser84113142lapser
lase46148512lase_
lased65132342lased
lasers64925702lasers
lases54944762lases
lasher94824532lasher
laster64830632laster
later54843922later
laver85031792laver
laxer125420332laxer
layer84626472layer
leaser65322672leaser
loser54728672loser
macer912126942macer
maker114127812maker
masers84623452masers
masher114123202masher
masker124416102masker
master84831342master
mater74438862mater
mazer165722422mazer
miser75430402miser
muser76024122muser
namer75622102namer
oases55330982oases
oater55433732oater
pacer96131612pacer
pager84728202pager
paler75436932paler
paper95128662paper
parer75839902parer
parser84822372parser
pase65346862pase_
paseo77022512paseo
pases75346502pases
passer84721032passer
paster85734372paster
pater74740722pater
pauser84415962pauser
paver104225832paver
pawer104422972pawer
payer105125722payer
poser75128772poser
racer75233022racer
raiser66620102raiser
raker94529792raker
raper74932752raper
rarer54731702rarer
rase46149982rase_
rased65033932rased
rasers64526782rasers
rases55447212rases
rasher95024122rasher
rasper83917332rasper
raster64731442raster
rater54943282rater
raver85631492raver
rawer84623732rawer
razer144824272razer
riser55431052riser
saber75330242saber
safer84721812safer
sager65432052sager
saker95132022saker
saner54334322saner
saver84831252saver
sawer85026212sawer
sayer84926552sayer
ser36752402__ser
taber73825822taber
taker95229002taker
taler56034862taler
tamer75230102tamer
taper74829772taper
taster64930572taster
tater54138612tater
tawer85223442tawer
taxer125019362taxer
teaser65421522teaser
user45023002_user
vase75629652vase_
vases84626262vases
vaster94521022vaster
wader95325362wader
wafer114417642wafer
wager95925052wager
waker125526592waker
waler84229262waler
washer124720392washer
waster95228942waster
water84733312water
waver115025702waver
waxer154317482waxer
wiser85522802wiser
yager95616752yager
yarer84321572yarer

Search took 5 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.360496363.9
2DLD Change Limit538003093.64014780.2
3Display Results3093090.0933322.6
 (SQL Overall)1786913094.09343657.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.