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

354 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
laker9543287(None) 
baker115629541baker
faker124824591faker
flaker134916171flaker
lacer75833751lacer
lacker125325621lacker
lader65633721lader
lager65132861lager
lake85741601lake_
laked105731121laked
lakers105225151lakers
lakes95737651lakes
lakier104716271lakier
lamer75233701lamer
lanker104123001lanker
larker104519241larker
laser54633321laser
later54843921later
laver85031791laver
laxer125420331laxer
layer84626471layer
leaker104620071leaker
liker95627061liker
maker114127811maker
raker94529791raker
saker95132021saker
slaker104219271slaker
taker95229001taker
waker125526591waker
ager55935842_ager
akee85936812_akee
alder65421912alder
alter54828502alter
aper66336232_aper
asker96418782asker
aver75931882_aver
backer144525522backer
bake105637512bake_
baked126130772baked
bakers125323452bakers
bakery155911002bakery
bakes117035372bakes
baler75635272baler
balker124519162balker
banker124222732banker
barer74535802barer
barker124822862barker
baser74828922baser
beaker125520692beaker
biker116022562biker
blacker154513512blacker
blader93618582blader
blamer104417142blamer
blanker134612022blanker
blazer174414022blazer
bleaker133510532bleaker
caber95126832caber
cager85229222cager
cake105439962cake_
caked126128622caked
cakes116037672cakes
cakey145517272cakey
cakier123115242cakier
calker124917082calker
caner75334772caner
canker124422522canker
caper94831622caper
carer74942332carer
cater74840702cater
caver105629062caver
clacker153813772clacker
claver113816972claver
clawer114512782clawer
dacker134920752dacker
daiker115113032daiker
danker114319662danker
darer65230792darer
darker114718692darker
dater65332312dater
diker105524552diker
eager65526962eager
eater54639842eater
elater64724202elater
esker94412982esker
facer105525052facer
fader94421512fader
fake115534942fake_
faked135225482faked
fakeer13378742fakeer
fakers134219532fakers
fakery16509262fakery
fakes126032482fakes
fakey155515422fakey
fakir125111492fakir
farer86733142farer
flake125119972flake_
flaked144715652flaked
flakers143613272flakers
flakes134118872flakes
flakey164410512flakey
flakier143910202flakier
flamer114919122flamer
flanker143911292flanker
flayer124713562flayer
gager74726292gager
gamer84928942gamer
gaper86125122gaper
gater64533642gater
gawker14559352gawker
gayer94519192gayer
gazer155720072gazer
glazer164212262glazer
hacker154822692hacker
hake115637842hake_
hakes126034302hakes
haler85033522haler
hanker134622092hanker
hater85034752hater
haver115124462haver
hawker164812662hawker
hayer114620242hayer
hazer174820232hazer
hiker125119392hiker
icker114018442icker
inker94421092inker
jacker194417582jacker
jager134318132jager
jake155925772jake_
jakes165023642jakes
japer146218882japer
joker165715892joker
laager74312782laager
label75019382label
labor75117312labor
lace66848472lace_
laced87132642laced
lacers85225252lacers
laces76141762laces
lacey105820912lacey
lacier84020092lacier
lacked135324652lacked
lackers134120542lackers
lackey154813352lackey
ladder84617622ladder
lade56345982lade_
laded74232612laded
laden65022192laden
laders74927762laders
lades65141272lades
ladler74314932ladler
lagers74826142lagers
lagger85919832lagger
lahar83114262lahar
lair45934152la_ir
lakh114919952lak_h
lakhs125210342lakhs
laky116725822lak_y
lamber104418492lamber
lame66849292lame_
lamed85235292lamed
lames75445542lames
lancer84319972lancer
lander74028482lander
lane45153322lane_
lanes54946792lanes
lankier113711632lankier
lanner64920592lanner
lapel73716682lapel
lapper104319952lapper
lapser84113142lapser
lar37967532la__r
larder73720972larder
laree56036292laree
lares54852632lares
larger74417512larger
larked114519472larked
larkers113014512larkers
larkier113711522larkier
lase46148512lase_
lased65132342lased
lasers64925702lasers
lases54944762lases
lasher94824532lasher
laster64830632laster
late47560482late_
lated65240672lated
laten54328342laten
latex124717112latex
lather95124352lather
latke94817092latke_
latkes104715872latkes
latter65027892latter
lauder73815012lauder
lave75642142lave_
laved95028592laved
laveer94110422laveer
lavers94526362lavers
laves86039152laves
lawed96028322lawed
lawyer12386972lawyer
laxes125430092laxes
layed95127382layed
layers93921182layers
lazar144113642lazar
laze136235052laze_
lazed154925842lazed
lazes145129572lazes
lazier154214612lazier
leader74824652leader
leaked114217702leaked
leakers113415422leakers
leakier114010992leakier
leaner64022192leaner
leaper88118942leaper
leaser65322672leaser
leaver94321512leaver
leer46239352l_eer
leger65721502leger
leke85527402leke_
leper74820742leper
lever85125162lever
liber74723612liber
licker125222042licker
lier45942462l_ier
lifer85822152lifer
liger65024462liger
like86040842like_
liked104523812liked
liken911818842liken
likers104620912likers
likes96231902likes
liner55938912liner
linker104321462linker
liter54736342liter
liver85132962liver
loader74316302loader
loafer93610942loafer
loaner64416502loaner
locker124019422locker
loner55431032loner
looker104816952looker
loper75129232loper
loser54728672loser
lover85526452lover
lower85830412lower
luger65322082luger
lunker104718342lunker
lurer54625312lurer
lurker103613292lurker
macer912126942macer
makar115614972makar
make105537882make_
makers123921732makers
makes115336852makes
marker124420392marker
maser75029972maser
masker124416102masker
mater74438862mater
mazer165722422mazer
naked105320852naked
namer75622102namer
oaken95814382oaken
oakier104011392oakier
oater55433732oater
ocker113915752ocker
pacer96131612pacer
packer144223402packer
pager84728202pager
paler75436932paler
paper95128662paper
parer75839902parer
parker124121372parker
pater74740722pater
paver104225832paver
pawer104422972pawer
payer105125722payer
piker115622842piker
placer105117742placer
planer84122652planer
plater84427692plater
player115215212player
poker115122882poker
quaker193811622quaker
racer75233022racer
racker124824552racker
rake84841572rake_
raked105831422raked
rakee96031172rakee
rakers104123572rakers
rakes94440352rakes
ranker105021902ranker
raper74932752raper
rarer54731702rarer
raser55633412raser
rater54943282rater
raver85631492raver
rawer84623732rawer
razer144824272razer
saber75330242saber
sacker125124842sacker
safer84721812safer
sager65432052sager
sake85244962sake_
sakers104125432sakers
sakes95540752sakes
saner54334322saner
saver84831252saver
sawer85026212sawer
sayer84926552sayer
shaker134319462shaker
siker95326032siker
slacker133915292slacker
slake93724052slake_
slaked114318272slaked
slakers114115752slakers
slakes104021882slakes
slater64429182slater
slaver94419612slaver
slayer93916332slayer
soaker105717532soaker
taber73825822taber
tacker124224502tacker
take84739262take_
taken94819142taken
takers103923742takers
takes94437792takes
taler56034862taler
talker103916222talker
tamer75230102tamer
tanker104521122tanker
taper74829772taper
tater54138612tater
tawer85223442tawer
taxer125019362taxer
toker95924912toker
wacker154920122wacker
wader95325362wader
wafer114417642wafer
wager95925052wager
wake114935702wake_
waked135626752waked
waken124818472waken
wakers134822492wakers
wakes126633652wakes
waler84229262waler
walker133913992walker
wanker134219972wanker
water84733312water
waver115025702waver
waxer154317482waxer
weaker134015442weaker
yager95616752yager
yakker12405532yakker
yarer84321572yarer

Search took 3 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.203880251.2
2DLD Change Limit538003542.11025497.6
3Display Results3543540.1103218.2
 (SQL Overall)1786913542.42373747.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.