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 “drapers” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
drapers10531335(None) 
diapers104713911diapers
draper94315691draper_
drapery13387941drapery
drapes95419651drape_s
drawers113610071drawers
rapers84327181_rapers
apers76629132__apers
bracers114616702bracers
bravers124715522bravers
brayers124511902brayers
brazers184513942brazers
capers105428142_capers
carpers114521252carpers
crapes104727692crape_s
crappers144011022crappers
craters95021892craters
cravers124416562cravers
dampers123915692dampers
darers75921872d_arers
darners83815772darners
darters84017602darters
daters74827372d_aters
dealers84118612dealers
dialers83614302dialers
diaper94513112diaper_
diapirs10347642diapirs
dippers123615182dippers
dopers95522482d_opers
dorpers104113172dorpers
drafters12338532drafters
dragees9359482dragees
draggers11357392draggers
drainers92811252drainers
drakes114715862drake_s
drape85319632drape__
draped105314362drape_d
draperies1249192draperies
drapey125010582drape_y
drawees11378362drawees
drawer104711362drawer_
drawlers12307312drawlers
dreamers11369002dreamers
driers74516732dr_iers
drippers13327942drippers
drivers114412792drivers
droners84114382droners
droppers13318602droppers
drovers115212642drovers
drupes94912652drupe_s
dryers10449272dr_yers
dumpers123412662dumpers
dupers94615602d_upers
erasers74413942erasers
framers125113822framers
fraters103517212fraters
gapers94520472_gapers
graders94716012graders
grapery13457952grapery
grapes95123122grape_s
graspers11338402graspers
graters85419742graters
gravers114515272gravers
grazers175112452grazers
gripers104011462gripers
gropers104813852gropers
harpers124916202harpers
heapers123616672heapers
japers154616172_japers
kraters114212342kraters
leapers93716662leapers
papers105125322_papers
praters94921652praters
prayers124212852prayers
propers113619032propers
racers84725432_racers
rakers104123572_rakers
raper74932752_raper_
rapes75740722_rape_s
rapiers95012872_rapiers
rappers113618442_rappers
rasers64526782_rasers
raspers94415922_raspers
raters63936582_raters
ravers94628182_ravers
razers154919612_razers
reapers93520452reapers
ropers84325902_ropers
scrapers125510532scrapers
shapers124016892shapers
soapers93715922soapers
tapers84025812_tapers
tracers94917842tracers
traders84316952traders
trampers123210392trampers
trapes85024462trape_s
trappers123711042trappers
warpers123413582warpers
wrappers15306932wrappers

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 Filter1786911076710.406440125.6
2DLD Change Limit107671994.03326697.5
3Display Results99990.0462152.2
 (SQL Overall)178691994.48539841.9
 
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.