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

199 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
scrapie11501094(None) 
scrape105917571scrap_e
scrapies124612471scrapies
crape96128442_crap_e
crappie13298982_crappie
sarape84817572sarap_e
scape96921842sc_ap_e
schappe1635262schappe
scrap97120402scrap__
scraped124313132scraped
scraper114513422scraper
scrapes116217662scrapes
scraping133310862scraping
scrapped1556532scrapped
scrapper1466972scrapper
scrappier1544422scrappier
scrapple1434682scrapple
scrappy16234472scrappy
scraps106017242scrap_s
scruple1137192scruple
serape84818412serap_e
sharpie1238392sharpie
acrasia9310033acrasia
acrasin9311223acrasin
cape87242783_c_ap_e
capiz18514563_c_apiz
carnie84421093_carnie
carpi94319393_carpi_
cavie104621593_c_avie
chape125221143_chap_e
chappie16298653_chappie
cheapie1437563cheapie
cowpie133511513_cowpie
cradle93313163_cradle
crake114823523_cra_ke
crambe1239073_crambe
crampier14288903_crampier
crampit1338863_crampit
crane75331603_cra_ne
crania82418433_crania
crap85731843_crap__
craped116120523_craped
crapes104727693_crapes
craping124018713_craping
crapped143912623_crapped
crapper133913193_crapper
crappier14288133_crappier
crappies142911153_crappies
crappy15446803_crappy
craps95328643_crap_s
crasis85020473_crasis
crate76537403_cra_te
crave105626313_cra_ve
craze165221463_cra_ze
crazier183610743_crazier
crazies183413853_crazies
creepie1137483_creepie
crepe95520723_crep_e
crepier1139743_crepier
cripe95521143_crip_e
croppie13278793_croppie
drape85319633_drap_e
escape103811663esc_ap_e
escapee113310463esc_apee
frappe13286953_frappe
grape84824663_grap_e
grapier103712603_grapier
porkpie1544673porkpie
ramie75027823__ramie
rape65041633__rap_e
raphe104916423__raphe
rapid86422033__rapid
rapier84019993__rapier
rapine85023083__rapine
sacralize2048973sacralize
sacraria1047393sacraria
sapid84720933s__apid
sarapes94617743sarapes
satrapies1147713satrapies
scabies11613333sc_abies
scale74629143sc_a_le
scalier94316913sc_alier
scampi12469103scampi_
scampies1439323scampies
scaped115519553sc_aped
scapes105122263sc_apes
scaping123715693sc_aping
scapose1147753sc_apose
scarce104013633sc_arce
scare75334463sc_a_re
scarfpin1553033scarfpin
scarier94017873sc_arier
scarp95724103scarp__
scarped124314403scarped
scarper114814823scarper
scarph13429603scarp_h
scarphed1635443scarphed
scarphs14437413scarphs
scarping133312463scarping
scarps104718603scarp_s
scarrier10298453scarrier
scathe114414993sc_athe
schappes1736033schappes
sciatic11910173sciatic
scope94821483sc_op_e
scottie937463scottie
scrabble14196993scrabble
scrag85916173scra__g
scragged1335823scragged
scraggier1344133scraggier
scraggy14304583scraggy
scrags95713803scra_gs
scraich1436763scraich
scraigh1335673scraigh
scram910621623scra__m
scramble14177253scramble
scramjet1945033scramjet
scrammed1555003scrammed
scrams105216623scra_ms
scrannel1044033scrannel
scrapers125510533scrapers
scrapheap1892003scrapheap
scrapings14255173scrapings
scrappage1642443scrappage
scrappers1545863scrappers
scrappiest1644153scrappiest
scrappily1842673scrappily
scrapping1635743scrapping
scrapples1534793scrapples
scratch1446013scratch
scrawl11208093scra_wl
scrawled1445923scrawled
scrawler1345893scrawler
scrawlier1443903scrawlier
scrawls12177283scrawls
scrawly15197193scrawly
scrawnier1443643scrawnier
scrawny15213943scrawny
scree720031713scr__ee
screwier1346433screwier
scribe104613533scr_ibe
scried95817303scr__ied
scries85226823scr__ies
scrieve12448333scrieve
scrim95419743scr__im
scrimpier1554243scrimpier
scrimpit1444183scrimpit
scrip96619193scr__ip
scrips105316033scrip_s
script105717903scrip_t
scripted13117553scripted
scripter12137783scripter
scripts11509373scripts
scrive115414943scr_ive
scrooge1037183scrooge
scrouge1036353scrouge
scrupled1335823scrupled
scruples1237433scruples
sculpin11236653sculpin
serai56830163sera_i_
serail64222673sera_il
serais64326133sera_is
serapes95218103serapes
seraph114011163serap_h
seraphic1546633seraphic
seraphim1544803seraphim
seraphin1345953seraphin
seraphs12408093seraphs
shape105125113s_hap_e
sharpies13411223sharpies
shavie124312423s_havie
shrapnel1342133shrapnel
sinopie948783sinopie
sirupier1034303sirupier
smartie9310173smartie
soapier93411713s_oapier
sortie63621993sor_tie
spavie113611383s_pavie
sprain83614863spra_in
staple84415823s_taple
strafe95215983stra_fe
strain64919573stra_in
strait64025893stra_it
strake104017393stra_ke
strange85416343strange
strap77925263strap__
strapped1357823strapped
strapper1258093strapper
strappier1345133strappier
strappy14205263strappy
straps87721783strap_s
strati63518903strati_
strawier1137493strawier
stripe85822443strip_e
stripier1058863stripier
strophe1239143strophe
sucrase9310343sucra_se
synapse1234133synapse
syrupier1343053syrupier

Search took 9 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 Limit1340271997.95316852.4
3Display Results1991990.0762618.4
 (SQL Overall)1786911998.43521184.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.