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 “lagers” 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
lagers7482614(None) 
agers65027851_agers
cagers95624191cagers
eagers74523681eagers
gagers84021331gagers
jagers144415721jagers
laagers83411251laagers
lacers85225251lacers
laders74927761laders
lager65132861lager_
laggers94216241laggers
lakers105225151lakers
lasers64925701lasers
lavers94526361lavers
layers93921181layers
legers74518311legers
ligers75022041ligers
lugers74617021lugers
pagers94423251pagers
wagers105122201wagers
yagers105114531yagers
agars66120642_agars
ager55935842_ager_
ages55844592_age_s
aggers85817792aggers
alders74218422alders
algors7312552algors
alters64924222alters
angers75222542angers
apers76629132_apers
augers73818702augers
avers85127312_avers
badgers114812652badgers
bagels95712312bagels
baggers113915692baggers
bakers125323452bakers
balers85626932balers
bangers104020352bangers
bladers104214682bladers
blamers115314212blamers
blazers184811682blazers
cabers105023922cabers
cadgers114712002cadgers
cager85229222cager_
cages85936012cage_s
caners84629202caners
capers105428142capers
carers85133962carers
caters85336502caters
cavers115026842cavers
clangers114312342clangers
clavers124314902clavers
clawers123910972clawers
daggers103714912daggers
dangers94818212dangers
darers75921872darers
daters74827372daters
eager65526972eager_
eagres74014572eagres
eaters65535952eaters
edgers84413922edgers
egers65120372_egers
eggers84612582eggers
elaters74420192elaters
facers115519442facers
faders105117462faders
fakers134219532fakers
farers95924052farers
flaggers13328072flaggers
flakers143613272flakers
flamers124616362flamers
flangers123311372flangers
flayers133912032flayers
gager74726292gager_
gages74529972gage_s
gaggers103413662gaggers
gamers94420832gamers
gangers94418602gangers
gapers94520472gapers
gaters74728642gaters
gaugers94211712gaugers
gazers164516302gazers
glazers174410042glazers
halers94926912halers
hangers113120812hangers
haters94930402haters
havers124721482havers
hayers124415942hayers
hazers184615952hazers
imagers10107762imagers
jaegers15307102jaegers
jager134318132jager_
jaggers164012892jaggers
japers154616172japers
laager74312782laager_
labels84515682labels
labors84016412labors
lacer75833752lacer_
laces76141762lace_s
lackers134120542lackers
ladders94115172ladders
ladens74516232ladens
lader65633722lader_
lades65141272lade_s
ladlers84613572ladlers
lagans75717782lagans
lagend838742lagend
lagends947272lagends
lagered92311152lagered
lagger85919832lagger_
lags56546222lag__s
lahars94013162lahars
lairs55425872la_irs
laker95432872laker_
lakes95737652lake_s
lambers113817112lambers
lameds94812032lameds
lamer75233702lamer_
lames75445542lame_s
lampers113817332lampers
lancers93616642lancers
landers84026212landers
lanes54946792lane_s
langurs889102langurs
lanners73618332lanners
lapels83712042lapels
lappers113717462lappers
lapsers93911052lapsers
larders83516942larders
larees65323112larees
lares54852632lare_s
larger74417512larger_
larges74824232large_s
largess8408912largess
larkers113014512larkers
lars46956572la__rs
laser54633322laser_
lases54944762lase_s
lashers104121832lashers
lasters75627692lasters
latens64620212latens
later54843922later_
lathers104321882lathers
lauders84012892lauders
laughers1235922laughers
laveers10329362laveers
laver85031792laver_
laves86039152lave_s
lawyers13377152lawyers
laxer125420332laxer_
laxes125430092laxe_s
layer84626472layer_
lazars153812392lazars
lazes145129572laze_s
leaders83819602leaders
leaguers935062leaguers
leakers113415422leakers
leaners73718172leaners
leapers93716662leapers
leasers74717842leasers
leavers103717782leavers
ledgers94912182ledgers
leers54828982l_eers
leger65721512leger_
leges64427292lege_s
lepers84817322lepers
levers94621322levers
libers84721442libers
liers55130402l_iers
lifers95617842lifers
liger65024472liger_
likers104620912likers
liners65428852liners
lingers84223302lingers
liters65429882liters
livers94927822livers
loaders83413432loaders
loafers10349462loafers
loaners73913622loaners
lodgers95113832lodgers
loges66534202loge_s
loggers94616132loggers
loners64225812loners
longers84819542longers
lopers84424142lopers
losers65123582losers
lovers94223432lovers
lowers94624922lowers
luger65322082luger_
luges65928752luge_s
luggers93713482luggers
lungers83817092lungers
lurers64217492lurers
macers105321272macers
mages85036022mage_s
makers123921732makers
mangers103521262mangers
masers84623452masers
maters85032392maters
mazers173917092mazers
naggers93812652naggers
namers84517332namers
oaters65029792oaters
onagers838102onagers
pacers105124542pacers
pager84728202pager_
pages85235072page_s
papers105125322papers
parers85530742parers
paters84935832paters
pavers115021822pavers
pawers114818782pawers
payers114621822payers
placers114515262placers
plages94520152plage_s
plaguers11286502plaguers
planers94517942planers
platers93924092platers
players124313762players
racers84725432racers
ragees74618662ragees
rages64539442rage_s
rakers104123572rakers
rangers83621042rangers
rapers84327182rapers
rasers64526782rasers
raters63936582raters
ravers94628182ravers
razers154919612razers
rogers74517912rogers
sabers85224732sabers
sager65432052sager_
sages65339062sage_s
saggers94017082saggers
sakers104125432sakers
sangers84421942sangers
saugers83914052saugers
savers93825922savers
sawers94620162sawers
sayers94221592sayers
slakers114115752slakers
slaters73123732slaters
slavers103716502slavers
slayers104513322slayers
stagers84116672stagers
swagers114211022swagers
tabers84621572tabers
taggers93514192taggers
takers103923742takers
talers64628142talers
tamers84224032tamers
tapers84025812tapers
taters64932202taters
tawers94118602tawers
taxers134015282taxers
tigers75616512tigers
urgers73313622urgers
waders109120642waders
wafers124316142wafers
wager95925052wager_
wages95330932wage_s
waggers124613082waggers
wakers134822492wakers
walers94824462walers
waters95030632waters
wavers125022472wavers
waxers164014302waxers
yager95616752yager_

Search took 4 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 Filter178691825510.703254183.5
2DLD Change Limit825512683.06026977.5
3Display Results2682680.0803350.0
 (SQL Overall)1786912683.84346497.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.