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

68 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
scrapes11621766(None) 
crapes104727691_crapes
sarapes94617751sarapes
scapes105122261sc_apes
scrape105917571scrape_
scraped124313131scraped
scraper114513421scraper
scrapers125510531scrapers
scrapies124612481scrapies
scraps106017241scrap_s
serapes95218101serapes
capes95441922_c_apes
chapes135421872_chapes
crakes124921812_crakes
cranes84330752_cranes
crape96128442_crape_
craped116120522_craped
craps95328642_crap_s
crases85532312_crases
crates85736062_crates
craves115825392_craves
crazes174720132_crazes
crepes105419342_crepes
cripes105120872_cripes
drapes95419652_drapes
escapes113811672esc_apes
grapes95123122_grapes
rapes75740722__rapes
sarape84817572sarape_
scales84529312sc_ales
scape96921842sc_ape_
scaped115519552sc_aped
scares85033002sc_ares
scarped124314402scarped
scarper114814822scarper
scarpers124712512scarpers
scarphs14437412scarphs
scarps104718602scarp_s
scarves124511622scarves
schappes1736042schappes
scopes104719592sc_opes
scrags95713802scra_gs
scrams105216622scra_ms
scrap97120402scrap__
scrapie115010942scrapie
scrapped1556532scrapped
scrapper1466972scrapper
scrappers1545862scrappers
scrapples1534802scrapples
scrappy16234472scrappy
scrawls12177282scrawls
screes85023972scr_ees
scribes113713202scribes
scries85226822scr_ies
scrips105316032scrip_s
scripts11509372scripts
scrives124414272scrives
scruples1237432scruples
serape84818412serape_
seraphs12408092seraphs
shapes115124952s_hapes
stapes85028732s_tapes
strafes104516002strafes
strakes114218072strakes
straps87721782strap_s
stripes95320572stripes
sucrases10310252sucrases
trapes85024462_trapes

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 Filter1786911076710.360496363.9
2DLD Change Limit107671682.98636058.6
3Display Results68680.0135230.8
 (SQL Overall)178691683.35953197.7
 
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.