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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

140 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
scrawny1521394(None) 
scrawly15197191scrawly
brawny144710602_brawny
cranny114210272_cranny
crawly144610762_crawly
scraggy14304582scraggy
scrappy16234472scrappy
scrawl11208092scraw_l
scrawls12177282scrawls
screwy14659462screw_y
sprawly15166042sprawly
strawy1210312822straw_y
awny105919303___awny
brainy114815643_brainy
branny115111833_branny
brawly144312353_brawly
brawn106018563_brawn_
brawns115614083_brawns
browny144510043_browny
canny105817693_c_anny
caraway1538133caraway
carny105822923_c_arny
crabby15346753_crabby
cracky175010223_cracky
crafty14478913_crafty
craggy13396603_craggy
crampy154710993_crampy
crane75331603_cra_ne
crank114819613_cra_nk
cranky153910633_cranky
crappy15446803_crappy
craw97725263_craw__
crawl104916713_craw_l
crawls114712083_crawls
craws105723123_craw_s
crazy195511223_cra_zy
crony105918673_cr_ony
crowdy15467173_crowdy
crown105620083_crown_
crowns115615113_crowns
drawly134910723_drawly
drawn95614243_drawn_
faraway1645413faraway
fawny144711713__fawny
grainy103914213_grainy
granny104311163_granny
lawny115912013__lawny
prawn105312433_prawn_
prawns11509023_prawns
rainy85921083__rainy
rawly115115833__rawly
saran53730303sara_n_
sarans64224433sara_ns
sawn75428163s__awn_
sawney12387603s__awney
scabby1535503sc_abby
scaly104718723sc_a_ly
scan65530453sc_a_n_
scans74625103sc_a_ns
scant79735073sc_a_nt
scanty114014663sc_anty
scarey115016983sc_arey
scarify1537443scarify
scarily12311703scarily
scaring103421973scaring
scarry116311183sc_arry
scary105222593sc_a_ry
scatty115310653sc_atty
scrabbly17164623scrabbly
scrag85916173scra__g
scraggly15294143scraggly
scrags95713803scra_gs
scraich1436763scraich
scraigh1335673scraigh
scram910621623scra__m
scrams105216623scra_ms
scrannel1044033scrannel
scrap97120403scra__p
scrape105917573scra_pe
scraped124313133scraped
scraper114513423scraper
scrapes116217663scrapes
scrapie115010943scrapie
scraping133310863scraping
scraps106017243scra_ps
scratch1446013scratch
scratchy1843653scratchy
scrawled1445923scrawled
scrawler1345893scrawler
scrawling15195583scrawling
scrawnier1443643scrawnier
screaky16436223screaky
screen85216023screen_
screens95212183screens
screw109318543screw__
screwed135710663screwed
screwer124410073screwer
screwing14288233screwing
screws115513893screw_s
screwup1442973screwup
scrimpy16486133scrimpy
scroggy14243843scroggy
scroungy1452563scroungy
scrubby1642803scrubby
scruffy1842643scruffy
scrutiny1344773scrutiny
scry96017763scr___y
scrying1338663scrying
seaway12309993s_eaway
shanny124110093s_hanny
sharny124711833s_harny
shawn116417613s_hawn_
shrank13359123shra_nk
spawn107811713s_pawn_
spawns11577923s_pawns
sprain83614863sprain_
sprains93013593sprains
sprang95713523spra_ng
sprawl11188063spraw_l
sprawls12176373sprawls
spray106720063spra__y
strain64919573strain_
strains74218153strains
stramony1344933stramony
strand74514823stra_nd
strang75718313stra_ng
strappy14205263strappy
straw813321293straw__
strawed114813613strawed
strawing122411623strawing
straws98718673straw_s
stray88525573stra__y
strewn96710013strewn_
strown96812093strown_
swanny12336823s_wanny
tawny114713653__tawny
thrawn12769423thrawn_
thrawnly1741793thrawnly
tranny94210863_tranny
tyranny1343063tyranny

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271406.60620288.7
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.05825317.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.