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

272 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
agers6502785(None) 
agars66120641agars
ager55935841ager_
ages55844591age_s
aggers85817791aggers
angers75222541angers
apers76629131apers
augers73818701augers
avers85127311avers
cagers95624181cagers
eagers74523681eagers
egers65120371egers
gagers84021321gagers
jagers144415721jagers
lagers74826141lagers
pagers94423251pagers
wagers105122201wagers
yagers105114531yagers
abets75621672abets
acerb9312762acerb
aces67645092ace_s
acres76327762acres
adders84315702adders
aegis6316782aegis
aero45435342a_ero
aery77231682a_ery
afars85716512afars
afters94717072afters
agar58726412agar_
agas55938842ag_as
age47154332age__
aged67334252age_d
agee56241492age_e
ageism968802ageism
ageist7315382ageist
agene65621582agene
agenes74720252agenes
agent65829642agent
agents74816292agents
agger76420892agger_
aggro738002aggro
aggros836542aggros
aghas97014872aghas
agios65919862agios
aglets73915682aglets
agmas85919872agmas
agons66423782agons
agora6914332agora
agoras7613342agoras
agree65226032agree
agrees74915322agrees
ags47551662ag__s
agues64919052agues
aiders74524632aiders
aimers84621912aimers
airers64922312airers
airs46447422a_irs
aivers94822322aivers
akees96119242akees
alders74218422alders
alecs76620732alecs
alefs87319662alefs
alert54740652alert
alerts64418222alerts
ales47067102ale_s
algors7312552algors
alters64924222alters
ambers104519562ambers
ameers84015572ameers
amens75624842amens
amirs75924912amirs
anears63717182anears
anes45255932ane_s
angels74416172angels
anger66225872anger_
anglers84014822anglers
aper66336232aper_
apery106517902apery
apes66047432ape_s
apres75426402apres
areas55935772areas
ares45871022are_s
arguers8489022arguers
armers85520272armers
ars37670932a__rs
askers105915402askers
aspers86220312aspers
asters65631602asters
ates45047922ate_s
auger64922472auger_
augurs7399962augurs
aures55137092aures
avens86419332avens
aver75931882aver_
averse95811182averse
avert86029492avert
averts95715242averts
aves76142602ave_s
awes76037552awe_s
axels126313632axels
axes117337852axe_s
ayes76543512aye_s
badgers114812642badgers
bagels95712312bagels
baggers113915692baggers
bakers125323452bakers
balers85626932balers
bangers104020352bangers
beers75628392beers
biers76225222biers
cabers105023902cabers
cadgers114711992cadgers
cager85229222cager_
cages85936012cage_s
caners84629192caners
capers105428132capers
carers85133952carers
caters85336492caters
cavers115026832cavers
daggers103714912daggers
dangers94818212dangers
darers75921872darers
daters74827362daters
deers64930522deers
doers65225712doers
dyers96617132dyers
eager65526962eager_
eagres74014572eagres
eaters65535942eaters
edgers84413912edgers
eger55923562eger_
eggers84612582eggers
ers36046282__ers
ewers86018822ewers
eyers86521332eyers
facers115519442facers
faders105117462faders
fakers134219532fakers
farers95924052farers
gaes56348032gae_s
gager74726292gager_
gages74529972gage_s
gaggers103413662gaggers
gamers94420822gamers
gangers94418602gangers
gapers94520462gapers
gars55750742_gars
gaters74728632gaters
gaugers94211702gaugers
gaurs66317992gaurs
gazers164516292gazers
gears64628692_gears
geds66730812_geds
gees55647882_gees
gels56836102_gels
gems75329112_gems
gens55740072_gens
germ75428962_germ
germs85118872_germs
gets55442482_gets
goers65520252goers
halers94926912halers
hangers113120812hangers
haters94930392haters
havers124721482havers
hayers124415942hayers
hazers184615952hazers
hers75844872_hers
hoers85724922hoers
imagers10107752imagers
jaegers15307102jaegers
jager134318132jager_
jaggers164012892jaggers
japers154616172japers
jeers124818132jeers
kiers95320092kiers
laagers83411252laagers
lacers85225252lacers
laders74927762laders
lager65132862lager_
laggers94216242laggers
lakers105225152lakers
lasers64925702lasers
lavers94526362lavers
layers93921182layers
leers54828982leers
legers74518312legers
liers55130402liers
ligers75022022ligers
lugers74617022lugers
macers105321272macers
mages85036022mage_s
makers123921732makers
mangers103521262mangers
masers84623452masers
maters85032382maters
mazers173917092mazers
naggers93812652naggers
namers84517332namers
oaters65029782oaters
ogees65119142ogees
oglers74313182oglers
ogres65818632ogres
omers76923192omers
onagers838102onagers
overs85224792overs
oyers87620882oyers
pacers105124542pacers
pager84728202pager_
pages85235072page_s
papers105125322papers
parers85530742parers
paters84935822paters
pavers115021822pavers
pawers114818782pawers
payers114621822payers
peers75130272peers
piers75926332piers
racers84725432racers
ragees74618662ragees
rages64539442rage_s
rakers104123572rakers
rangers83621042rangers
rapers84327182rapers
rasers64526782rasers
raters63936572raters
ravers94628182ravers
razers154919612razers
rogers74517912rogers
ruers515019412ruers
sabers85224732sabers
sager65432052sager_
sages65339062sage_s
saggers94017082saggers
sakers104125432sakers
sangers84421942sangers
saugers83914052saugers
savers93825922savers
sawers94620162sawers
sayers94221592sayers
seers55136382seers
sers45746652_sers
stagers84116672stagers
suers55128482suers
swagers114211022swagers
tabers84621572tabers
taggers93514192taggers
takers103923742takers
talers64628142talers
tamers84224032tamers
tapers84025812tapers
taters64932192taters
tawers94118602tawers
taxers134015282taxers
tiers55526522tiers
tigers75616502tigers
tyers86220052tyers
urgers73313622urgers
users55817572users
veers84521362veers
viers85621952viers
waders109120642waders
wafers124316142wafers
wager95925052wager_
wages95330932wage_s
waggers124613082waggers
wakers134822492wakers
walers94824462walers
waters95030622waters
wavers125022472wavers
waxers164014302waxers
yager95616752yager_

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.0931921408.6
2DLD Change Limit538002721.48336277.8
3Display Results2722720.0803400.0
 (SQL Overall)1786912721.656107905.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.