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

106 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
scrap9712040(None) 
crap85731841_crap
scarp95724101scarp
scrag85916171scrag
scram910621621scram
scrape105917571scrape
scraps106017241scraps
scrip96619191scrip
strap77925261strap
cap76758982_c_ap
carp85139812_carp
chap114928492_chap
clap86429042_clap
crab85727672_crab
crag75625302_crag
cram85635492_cram
cramp115120692_cramp
crape96128442_crape
craps95328642_craps
craw97725262_craw
crop87628632_crop
escarp10449002escarp
frap95925812_frap
rap56261962__rap
sacra74516992sacra_
sacral83414412sacral
sap56463232s__ap
saran53730302saran
sarape84817572sarape
satrap86212552satrap
scab85926712sc_ab
scad75725772sc_ad
scag76626892sc_ag
scalp95217982scalp
scam85932352sc_am
scamp115717312scamp
scan65530452sc_an
scape96921842sc_ape
scar66434202sc_ar
scarab10310062scarab
scare75334462scare
scarf105427142scarf
scarph13429602scarph
scarps104718602scarps
scars75433532scars
scart76139772scart
scary105222592scary
scat65848372sc_at
scaup95515992scaup
schav1338312schav
scoop95617162scoop
scop85925522sc_op
scrags95713802scrags
scrams105216622scrams
scraped124313132scraped
scraper114513422scraper
scrapes116217662scrapes
scrapie115010942scrapie
scrappy16234472scrappy
scrawl11208092scrawl
screak125311062screak
scream104814252scream
scree720031712scree
screw109318542screw
scrim95419742scrim
scrimp125110582scrimp
scrips105316032scrips
script105717902script
scrod85115072scrod
scroop10299782scroop
scrub94914202scrub
scrum95418202scrum
scry96017762scr_y
sculp95314842sculp
scup84822382sc_up
sera46141392sera_
serac75925202serac
serai56830162serai
seral56336382seral
serape84818412serape
seraph114011162seraph
sharp104922532sharp
sirup74014912sirup
slap66434042s_lap
snap65727032s_nap
sneap75514822sneap
soap65831132s_oap
sora45746912sora_
soras55041012soras
sprag86418692sprag
sprat76635972sprat
spray106720062spray
straps87721782straps
straw813321292straw
stray88525572stray
strep77120852strep
strip77524342strip
strop77422242strop
sura45740292sura_
surah86823252surah
sural55931262sural
suras55336332suras
swap95925432s_wap
syrup103010962syrup
trap67532802_trap
wrap96821972_wrap

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 Filter178691538000.436409841.7
2DLD Change Limit538001061.58034050.6
3Display Results1061060.0303533.3
 (SQL Overall)1786911062.04687336.8
 
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.