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 “scrape” 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
scrape10591757(None) 
crape96128441_crape
sarape84817571sarape
scape96921841sc_ape
scrap97120401scrap_
scraped124313131scraped
scraper114513401scraper
scrapes116217661scrapes
scrapie115010941scrapie
scraps106017241scraps
serape84818411serape
cape87242782_c_ape
chape125221142_chape
crake114823522_crake
crane75331602_crane
crap85731842_crap_
craped116120522_craped
crapes104727692_crapes
craps95328642_craps
crate76537402_crate
crave105626312_crave
craze165221462_craze
crepe95520722_crepe
cripe95521142_cripe
drape85319632_drape
escape103811662esc_ape
grape84824662_grape
rape65041632__rape
sarapes94617742sarapes
scale74629142sc_ale
scaped115519552sc_aped
scapes105122262sc_apes
scarce104013632scarce
scare75334462sc_are
scarp95724102scarp_
scarped124314392scarped
scarper114814822scarper
scarph13429602scarph
scarps104718602scarps
schappe1635262schappe
scope94821482sc_ope
scrag85916172scra_g
scrags95713802scrags
scram910621612scra_m
scrams105216622scrams
scrapers125510512scrapers
scrapies124612472scrapies
scrapped1556532scrapped
scrapper1466952scrapper
scrapple1434682scrapple
scrappy16234472scrappy
scrawl11208082scrawl
scree720031702scr_ee
scribe104613522scribe
scrip96619192scrip_
scrips105316032scrips
script105717902script
scrive115414942scrive
scruple1137192scruple
serapes95218102serapes
seraph114011162seraph
shape105125112s_hape
strafe95215972strafe
strake104017392strake
strap77925262strap_
straps87721782straps
stripe85822442stripe
sucrase9310342sucrase

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.186960704.3
2DLD Change Limit82551682.48333246.5
3Display Results68680.0164250.0
 (SQL Overall)178691682.68566551.6
 
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.