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

279 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
capers10542814(None) 
apers76629131_apers
cabers105023921cabers
cagers95624191cagers
campers134220291campers
caners84629201caners
caper94831621caper_
capes95441921cape_s
cappers134419401cappers
carers85133961carers
carpers114521251carpers
caters85336501caters
cavers115026841cavers
copers104629841copers
gapers94520471gapers
japers154616171japers
papers105125321papers
rapers84327181rapers
tapers84025811tapers
agers65027852_agers
aper66336232_aper_
apery106517902_apery
apes66047432_ape_s
apres75426402_apres
aspers86220312aspers
avers85127312_avers
bakers125323452bakers
balers85626932balers
caber95126832caber_
cablers114416712cablers
cades85440732cade_s
cadets96316512cadets
cadgers114712002cadgers
cadres94017932cadres
cafes106426922cafe_s
cager85229222cager_
cages85936012cage_s
cahiers123510672cahiers
cakes116037672cake_s
calipers1249442calipers
calkers134414692calkers
callers94221962callers
cambers134017442cambers
camels105217082camels
cameos105818002cameos
camera10313692camera
cameras11313362cameras
cames97047312came_s
camper124722212camper_
cancers114018582cancers
caner75334772caner_
canes75350372cane_s
cankers134418752cankers
canners93822662canners
canoers94318372canoers
canters94827732canters
cape87242782cape__
caped104931802cape_d
capered123014042capered
caperer113013402caperer
caperers122611722caperers
caphs124515372cap_hs
capias10318352capias
capless114312762capless
caplets114914522caplets
capons104119502capons
capos94826072cap_os
capper124421982capper_
capris10415082capris
caps87147892cap__s
captors113914982captors
carders104820352carders
careers95218782careers
carer74942332carer_
cares77369182care_s
caress85720262caress
carets85330772carets
carpels115315462carpels
carper104923632carper_
carpets113915332carpets
carrs75730852ca_rrs
cars67364762ca__rs
carters95327252carters
carvers124817532carvers
casern84713312casern
caserns94711222caserns
cases75048382case_s
casters94729902casters
cater74840722cater_
cates75951892cate_s
causers94014792causers
caver105629062caver_
cavern115312452cavern
caverns124510252caverns
caves105639702cave_s
ceders93817672ceders
cepes94424462cepe_s
chafers154512742chafers
champers173311622champers
chapels14429152chapels
chapes135421872chape_s
chapters154012132chapters
chasers123714922chasers
chawers154412052chawers
cheers114518912cheers
ciders94620092ciders
ciphers14379992ciphers
citers85022982citers
clampers143211892clampers
clappers143310832clappers
claspers124410912claspers
clavers124314902clavers
clawers123910972clawers
coalers94419352coalers
coaters93525792coaters
coaxers164311082coaxers
coders95426982coders
comers105328082comers
cooers84324562cooers
coopers114019482coopers
copens106119962copens
coper95336092coper_
copes97747102cope_s
copiers114215962copiers
coppers133519752coppers
copters113621282copters
corers85231072corers
covers114627962covers
cowers114625532cowers
crapes104727692crape_s
crappers144011022crappers
craters95021892craters
cravers124416552cravers
criers83918582criers
cubers105318352cubers
cupels10310202cupels
cuppers133712212cuppers
curers84923192curers
cyders12398832cyders
cyphers17316752cyphers
cypres1338522cypres
dampers123915692dampers
darers75921872darers
daters74827372daters
diapers104713912diapers
dopers95522482dopers
drapers105313352drapers
dupers94615602dupers
eagers74523682eagers
eaters65535952eaters
escapers12337412escapers
facers115519442facers
faders105117462faders
fakers134219532fakers
farers95924052farers
gagers84021332gagers
gamers94420832gamers
gaper86125122gaper_
gapes86030822gape_s
gaspers105014132gaspers
gaters74728642gaters
gawpers13448312gawpers
gazers164516302gazers
halers94926912halers
hampers143616952hampers
harpers124916202harpers
haters94930402haters
havers124721482havers
hayers124415942hayers
hazers184615952hazers
heapers123616672heapers
hopers114222972hopers
hypers144811912hypers
jagers144415722jagers
japer146218882japer_
japery18439142japery
japes146322822jape_s
jaspers164310462jaspers
lacers85225252lacers
laders74927762laders
lagers74826142lagers
lakers105225152lakers
lampers113817332lampers
lapels83712042lapels
lappers113717462lappers
lapsers93911052lapsers
lasers64925702lasers
lavers94526362lavers
layers93921182layers
leapers93716662leapers
lepers84817322lepers
lopers84424142lopers
macers105321272macers
makers123921732makers
mappers133313782mappers
masers84623452masers
maters85032392maters
mazers173917092mazers
mopers104220372mopers
namers84517332namers
napery11489812napery
napes74828462nape_s
nappers114214862nappers
oaters65029792oaters
pacers105124542pacers
pagers94423252pagers
pampers133615932pampers
paper95128662paper_
papery134812742papery
parers85530742parers
paters84935832paters
paupers114311072paupers
pavers115021822pavers
pawers114818782pawers
payers114621822payers
pipers104318662pipers
racers84725432racers
rakers104123572rakers
raper74932752raper_
rapes75740722rape_s
rapiers95012872rapiers
rappers113618442rappers
rasers64526782rasers
raspers94415922raspers
raters63936582raters
ravers94628182ravers
razers154919612razers
reapers93520452reapers
ropers84325902ropers
sabers85224732sabers
sakers104125432sakers
sapors84118812sapors
sappers113518902sappers
savers93825922savers
sawers94620162sawers
sayers94221592sayers
scalers93817262scalers
scalpers123710862scalpers
scampers143611032scampers
scapes105122262scape_s
scarers94618502scarers
scarpers124712512scarpers
scaupers12378172scaupers
scrapers125510522scrapers
shapers124016892shapers
soapers93715922soapers
supers84622402supers
tabers84621572tabers
takers103923742takers
talers64628142talers
tamers84224032tamers
tampers113516742tampers
taper74829772taper_
tapes75838602tape_s
tapirs84113172tapirs
tappers113416542tappers
taters64932202taters
tawers94118602tawers
taxers134015282taxers
topers85025322topers
uppers102912292uppers
vampers143111622vampers
vapors113812692vapors
vipers114914532vipers
waders109120642waders
wafers124316142wafers
wagers105122202wagers
wakers134822492wakers
walers94824462walers
warpers123413582warpers
waters95030632waters
wavers125022472wavers
waxers164014302waxers
wipers115416082wipers
yagers105114532yagers
yappers144012252yappers
yaupers12337662yaupers
yawpers15346852yawpers
zappers203911632zappers

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 Filter178691825510.1101624463.6
2DLD Change Limit825512792.40634310.5
3Display Results2792790.0763671.1
 (SQL Overall)1786912792.59268939.4
 
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.