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

228 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
pagers9442325(None) 
agers65027851_agers
cagers95624181cagers
eagers74523681eagers
gagers84021321gagers
jagers144415721jagers
lagers74826141lagers
pacers105124541pacers
pager84728201pager_
pages85235071page_s
papers105125321papers
parers85530741parers
paters84935821paters
pavers115021821pavers
pawers114818781pawers
payers114621821payers
wagers105122201wagers
yagers105114531yagers
agars66120642_agars
ager55935842_ager_
ages55844592_age_s
aggers85817792aggers
angers75222542angers
apers76629132_apers
augers73818702augers
avers85127312_avers
badgers114812642badgers
bagels95712312bagels
baggers113915692baggers
bakers125323452bakers
balers85626932balers
bangers104020352bangers
cabers105023902cabers
cadgers114711992cadgers
cager85229222cager_
cages85936012cage_s
caners84629192caners
capers105428132capers
carers85133952carers
caters85336492caters
cavers115026832cavers
daggers103714912daggers
dangers94818212dangers
darers75921872darers
daters74827362daters
eager65526962eager_
eagres74014572eagres
eaters65535942eaters
edgers84413912edgers
egers65120372_egers
eggers84612582eggers
facers115519442facers
faders105117462faders
fakers134219532fakers
farers95924052farers
gager74726292gager_
gages74529972gage_s
gaggers103413662gaggers
gamers94420822gamers
gangers94418602gangers
gapers94520462gapers
gaters74728632gaters
gaugers94211702gaugers
gazers164516292gazers
halers94926912halers
hangers113120812hangers
haters94930392haters
havers124721482havers
hayers124415942hayers
hazers184615952hazers
imagers10107752imagers
jaegers15307102jaegers
jager134318132jager_
jaggers164012892jaggers
japers154616172japers
laagers83411252laagers
lacers85225252lacers
laders74927762laders
lager65132862lager_
laggers94216242laggers
lakers105225152lakers
lasers64925702lasers
lavers94526362lavers
layers93921182layers
legers74518312legers
ligers75022032ligers
lugers74617022lugers
macers105321272macers
mages85036022mage_s
makers123921732makers
mangers103521262mangers
masers84623452masers
maters85032382maters
mazers173917092mazers
naggers93812652naggers
namers84517332namers
oaters65029782oaters
onagers838102onagers
pacer96131612pacer_
paces96741112pace_s
packers153818892packers
padders113312872padders
padres95016982padres
pagans95717922pagans
page76036102page__
paged95926782page_d
pagods105310192pagods
pairs75325832pa_irs
paler75436932paler_
pales75753802pale_s
palets85122312palets
palmers113513622palmers
palters94021682palters
pampers133615932pampers
panders103423732panders
panels84716522panels
panes76148692pane_s
pangens103112062pangens
paniers94717332paniers
panners93621272panners
panzers184012012panzers
paper95128662paper_
papery134812742papery
pareos87023772pareos
parer75839902parer_
pares77164482pare_s
pareus85420742pareus
parges94529542parge_s
pargets105215192pargets
parkers133816872parkers
parrs75928672pa_rrs
pars67560792pa__rs
parsers94118152parsers
paseos88015812paseos
pases75346502pase_s
passers94717752passers
pasters94531732pasters
patens84820862patens
pater74740722pater_
pates76047892pate_s
patters94825192patters
patzers184210572patzers
paupers114311072paupers
pausers94113222pausers
paver104225832paver_
paves104833922pave_s
pawer104422972pawer_
pawners124311072pawners
paxes144928422paxe_s
payees114812902payees
payer105125722payer_
payors114312642payors
peages94321842peage_s
peers75130272p_eers
peters86624592peters
phages125213512phage_s
piers75926332p_iers
pikers124717392pikers
pingers104020742pingers
pipers104318662pipers
placers114515262placers
plages94520152plage_s
plaguers11286502plaguers
planers94517942planers
platers93924082platers
players124313762players
pliers84715152pliers
plyers114912982plyers
pogeys124110352pogeys
pokers124617922pokers
polers84225642polers
posers84223972posers
powers113822322powers
praters94921642praters
prayers124212852prayers
priers84521192priers
pryers115012242pryers
pulers83820282pulers
purgers104714002purgers
racers84725432racers
ragees74618662ragees
rages64539442rage_s
rakers104123572rakers
rangers83621042rangers
rapers84327182rapers
rasers64526782rasers
raters63936572raters
ravers94628182ravers
razers154919612razers
rogers74517912rogers
sabers85224732sabers
sager65432052sager_
sages65339062sage_s
saggers94017082saggers
sakers104125432sakers
sangers84421942sangers
saugers83914052saugers
savers93825922savers
sawers94620162sawers
sayers94221592sayers
spacers113813872spacers
spaders104214472spaders
sparers94519612sparers
spargers11389732spargers
stagers84116672stagers
swagers114211022swagers
tabers84621572tabers
taggers93514192taggers
takers103923742takers
talers64628142talers
tamers84224032tamers
tapers84025812tapers
taters64932192taters
tawers94118602tawers
taxers134015282taxers
tigers75616502tigers
urgers73313622urgers
waders109120642waders
wafers124316142wafers
wager95925052wager_
wages95330932wage_s
waggers124613082waggers
wakers134822492wakers
walers94824462walers
waters95030622waters
wavers125022472wavers
waxers164014302waxers
yager95616752yager_

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 Filter178691825510.1231452772.4
2DLD Change Limit825512284.36018933.7
3Display Results2282280.0763000.0
 (SQL Overall)1786912284.55939195.2
 
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.