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

281 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
rapers8432718(None) 
apers76629131_apers
capers105428141capers
drapers105313351drapers
gapers94520471gapers
japers154616171japers
papers105125321papers
racers84725431racers
rakers104123571rakers
raper74932751raper_
rapes75740721rape_s
rapiers95012871rapiers
rappers113618441rappers
rasers64526781rasers
raspers94415921raspers
raters63936581raters
ravers94628181ravers
razers154919611razers
reapers93520451reapers
ropers84325901ropers
tapers84025811tapers
agers65027852_agers
aper66336232_aper_
apery106517902_apery
apes66047432_ape_s
apres75426402_apres
armers85520272armers
arpens84814822arpens
aspers86220312aspers
avers85127312_avers
bakers125323452bakers
balers85626932balers
bracers114616702bracers
bravers124715522bravers
brayers124511902brayers
brazers184513942brazers
cabers105023922cabers
cagers95624192cagers
campers134220292campers
caners84629202caners
caper94831622caper_
capes95441922cape_s
cappers134419402cappers
carers85133962carers
carpers114521252carpers
caters85336502caters
cavers115026842cavers
copers104629842copers
crapes104727692crape_s
crappers144011022crappers
craters95021892craters
cravers124416552cravers
dampers123915692dampers
darers75921872darers
daters74827372daters
diapers104713912diapers
dopers95522482dopers
draper94315692draper_
drapery13387942drapery
drapes95419652drape_s
drawers113610072drawers
dupers94615602dupers
eagers74523682eagers
eaters65535952eaters
erasers74413942erasers
facers115519442facers
faders105117462faders
fakers134219532fakers
farers95924052farers
framers125113822framers
fraters103517212fraters
gagers84021332gagers
gamers94420832gamers
gaper86125122gaper_
gapes86030822gape_s
gaspers105014132gaspers
gaters74728642gaters
gawpers13448312gawpers
gazers164516302gazers
graders94716012graders
grapery13457952grapery
grapes95123122grape_s
graspers11338402graspers
graters85419742graters
gravers114515272gravers
grazers175112452grazers
gripers104011462gripers
gropers104813852gropers
halers94926912halers
hampers143616952hampers
harpers124916202harpers
haters94930402haters
havers124721482havers
hayers124415942hayers
hazers184615952hazers
heapers123616672heapers
hopers114222972hopers
hypers144811912hypers
jagers144415722jagers
japer146218882japer_
japery18439142japery
japes146322822jape_s
jaspers164310462jaspers
kraters114212342kraters
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
praters94921652praters
prayers124212852prayers
propers113619032propers
racer75233022racer_
races74943242race_s
rackers134320452rackers
radars71314672radars
rafters103715632rafters
ragees74618662ragees
rages64539442rage_s
raiders84615142raiders
railers74420662railers
raisers73617392raisers
rajes125022782raje_s
rakees104516972rakees
raker94529792raker_
rakes94440352rake_s
rales54947492rale_s
ramees84620892ramees
ramets83517392ramets
rammers113715042rammers
ranees64623962ranees
rangers83621042rangers
rankers113217462rankers
ranters73323642ranters
rape65041632rape__
raped85334622rape_d
raphes115117452raphes
raphis114014322raphis
rapids94913892rapids
rapier84019992rapier_
rappees113611452rappees
rappels11448802rappels
rapper104621572rapper_
raps66247732rap__s
raptors94213352raptors
rarer54731702rarer_
rares55247442rare_s
raser55633412raser_
rases55447212rase_s
rashers104020912rashers
rasper83917332rasper_
rasters74629022rasters
ratels64518212ratels
rater54943282rater_
rates55352012rate_s
ratters74422472ratters
ravels94717072ravels
ravens93916882ravens
raver85631492raver_
raves85441972rave_s
rawer84623732rawer_
raxes124729392raxe_s
razees154314762razees
razer144824272razer_
razes145032702raze_s
razors154711662razors
readers83823772readers
reamers94221082reamers
reaper84223142reaper_
rearers74323562rearers
reavers108320742reavers
refers93921082refers
repapers1258832repapers
repegs93311942repegs
repels84318762repels
reperk122511772reperk
reperks13298092reperks
revers94529632revers
ricers84120992ricers
riders74123902riders
rimers84522552rimers
ripens85012172ripens
riper74328402riper_
ripes75435772ripe_s
rippers114115032rippers
risers64624782risers
rivers94626542rivers
roamers93713462roamers
roarers73812742roarers
rogers74517912rogers
rompers113412242rompers
roper75431912roper_
ropery114313872ropery
ropes75940062rope_s
rovers95423522rovers
rowers94924572rowers
ruers515019412r_uers
rulers64317092rulers
rupees8312572rupees
sabers85224732sabers
sakers104125432sakers
sapors84118812sapors
sappers113518902sappers
savers93825922savers
sawers94620162sawers
sayers94221592sayers
scrapers125510532scrapers
shapers124016892shapers
soapers93715922soapers
supers84622402supers
tabers84621572tabers
takers103923742takers
talers64628142talers
tamers84224032tamers
tampers113516742tampers
taper74829772taper_
tapes75838602tape_s
tapirs84113172tapirs
tappers113416542tappers
taters64932202taters
tawers94118602tawers
taxers134015282taxers
topers85025322topers
tracers94917842tracers
traders84316952traders
trampers123210392trampers
trapes85024462trape_s
trappers123711042trappers
uppers102912292uppers
vampers143111622vampers
vapors113812692vapors
vipers114914532vipers
waders109120642waders
wafers124316142wafers
wagers105122202wagers
wakers134822492wakers
walers94824462walers
warpers123413582warpers
waters95030632waters
wavers125022472wavers
waxers164014302waxers
wipers115416082wipers
wrappers15306932wrappers
yagers105114532yagers
yappers144012252yappers
yaupers12337662yaupers
yawpers15346852yawpers
zappers203911632zappers

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.516346300.4
2DLD Change Limit825512812.87328733.4
3Display Results2812810.0933021.5
 (SQL Overall)1786912813.48251318.5
 
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.