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

285 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
scrawls1217728(None) 
crawls114712081_crawls
scrawl11208091scrawl_
scrawly15197191scrawly
sprawls12176371sprawls
becrawls1543622becrawls
brawls115214332_brawls
craals84113302_craals
crawl104916712_crawl_
crawly144610762_crawly
craws105723122_craw_s
drawls105511392_drawls
sacrals93311792sacra_ls
scalls84218202sc_alls
scowls11549592sc_owls
scrags95713802scra_gs
scrams105216622scra_ms
scrapes116217662scrapes
scraps106017242scra_ps
scrawled1445922scrawled
scrawler1345892scrawler
scrawlers1434752scrawlers
scrawny15213942scrawny
screws115513892screw_s
scrolls938062scrolls
serails73318362serails
shawls125411972s_hawls
sprawl11188062sprawl_
sprawly15166042sprawly
straws98718672straw_s
trawls94412392_trawls
astrals75515243astra_ls
awls75926093___awls
bawls105719323__bawls
becrawl1444583becrawl_
borals86721913bora_ls
brails84621293_brails
brawl106217963_brawl_
brawly144312353_brawly
brawns115614083_brawns
braws106425193_braw_s
calls75634733_c_alls
carls77037423_c_arls
carols85124983_carols
cauls75727773_c_auls
caws96036113_c_aw_s
chaws135022463_chaw_s
claws106020833_claw_s
coals76129603_coa_ls
corals85325143cora_ls
cowls106922213_c_owls
craal74117753_craal_
crabs95421393_cra_bs
cracks144817003_cracks
cradle93313163_cradle
cradles103114133_cradles
crafts115312743_crafts
crags85622573_cra_gs
crakes124921813_crakes
cramps125615563_cramps
crams96229153_cra_ms
cranes84330753_cranes
cranks125015313_cranks
crapes104727693_crapes
craps95328643_cra_ps
crases85532313_crases
crasis85020473_crasis
crass76328043_cra_ss
crates85736063_crates
craves115825393_craves
craw97725263_craw__
crawled133710403_crawled
crawler123510463_crawler
crawlers13309013_crawlers
crazes174720133_crazes
creels84416943_creels
crewels12438493_crewels
crews105917503_crew_s
crowds124910763_crowds
crowns115615113_crowns
crows105727313_crow_s
derails84216393derails
drails74716953_drails
drawl95516013_drawl_
drawly134910723_drawly
draws95119373_draw_s
escrows1235803escrow_s
ferals94216643fera_ls
frails93716473_frails
gorals76917653gora_ls
graals74112913_graals
grails77518783_grails
growls104711113_growls
kraals10378433_kraals
morals85324633mora_ls
murals84016763mura_ls
narwals1036983narwals
orals55826483_ora_ls
outcrawls1443513outcrawls
pawls105617663__pawls
prawns11509023_prawns
prowls115511083_prowls
rails55937403__rails
rawly115115833__rawly
raws75238213__raw_s
sabals84618863saba_ls
sacral83414413sacra_l_
sails55738103s__ails
salals65120083sala_ls
sals46851673s__a_ls
sarans64224433sara_ns
sarapes94617743sarapes
sauls55128123s__auls
saws75839483s__aw_s
scabs94818643sc_a_bs
scads85419963sc_a_ds
scags85520973sc_a_gs
scald84818123sc_a_ld
scalds94813693sc_alds
scale74629143sc_a_le
scales84529313sc_ales
scall74420373sc_a_ll
scalp95217983sc_a_lp
scalps104315233sc_alps
scaly104718723sc_a_ly
scamps125014173sc_amps
scams94423973sc_a_ms
scans74625103sc_a_ns
scants85219723sc_ants
scapes105122263sc_apes
scarabs1137293scarabs
scarers94618513scarers
scares85033003sc_ares
scarfs114714683sc_arfs
scarily12311703scarily
scarphs14437413scarphs
scarps104718603sc_arps
scars75433533sc_a_rs
scarts85321493sc_arts
scarves124511623scarves
scats75930603sc_a_ts
scatts85914663sc_atts
scaups105411933sc_aups
scaurs85512053sc_aurs
schavs1436493scha_vs
schools1249113schools
schorls1248353schorls
schuls11299853sc_huls
schwas14396983sc_hwas
sclaffs1543573sclaffs
scowl1012012973sc_owl_
scows106617803sc_ow_s
scrabble14196993scrabble
scrabbles15206283scrabbles
scrabbly17164623scrabbly
scrag85916173scra__g
scraggly15294143scraggly
scraggy14304583scraggy
scraich1436763scraich
scraichs1543993scraichs
scraigh1335673scraigh
scraighs1443633scraighs
scram910621623scra__m
scramble14177253scramble
scrambles15146383scrambles
scrannels1143513scrannels
scrap97120403scra__p
scrape105917573scra_pe
scraped124313133scraped
scraper114513423scraper
scrapers125510533scrapers
scrapie115010943scrapie
scrapies124612473scrapies
scrapple1434683scrapple
scrapples1534793scrapples
scrappy16234473scrappy
scratch1446013scratch
scrawlier1443903scrawlier
scrawliest1553813scrawliest
scrawling15195583scrawling
screaks13469363screaks
screams114810623screams
screeds106210293screeds
screens95212183screens
screes85023973scr_ees
screw109318543screw__
screwed135710663screwed
screwer124410073screwer
screwers13358063screwers
screwup1442973screwup
screwups1542293screwups
screwy14659463screw_y
scribes113713203scribes
scries85226823scr_ies
scrimps13517903scrimps
scrims104615933scr_ims
scrips105316033scr_ips
scripts11509373scripts
scrives124414273scrives
scrods94111613scr_ods
scroll8310173scr_oll
scroops11288253scroops
scrubs104210313scr_ubs
scruffs1554173scruffs
scrums104614253scr_ums
scruple1137193scruple
scruples1237433scruples
sculls84613883sc_ulls
seals54839693s_ea_ls
sepals85217373sepa_ls
seracs84418573sera_cs
serail64222673serail_
serais64326133sera_is
seral56336383sera_l_
serapes95218103serapes
seraphs12408093seraphs
serials73919743serials
serows96016393serow_s
servals103410743servals
shauls94913113s_hauls
shawl116217573s_hawl_
shawms14579563s_hawms
shaws116226263s_haw_s
sheals94420643shea_ls
shoals94215793shoa_ls
shrews129313923shrew_s
shrills10389933shrills
sials54227243s_ia_ls
sisals63013573sisa_ls
skoals10438243skoa_ls
slaws85222713s_law_s
smalls84514123s_malls
snails64816653s_nails
snarls64016873s_narls
snaws86116363s_naw_s
socials999633socia_ls
soras55041013sora__s
sorels63921163sor_els
sorrels7310723sorrels
spails84817823s_pails
spalls84217343s_palls
spawns11577923s_pawns
spirals93212513spira_ls
sprags95715823spra_gs
sprains93013593sprains
sprangs104610053sprangs
sprats85819933spra_ts
sprawled1434523sprawled
sprawler1334653sprawler
sprawlers1433903sprawlers
sprays115913643spra_ys
squalls1647313squalls
squawks23294883squawks
squaws18438783squaw_s
stalls64019933s_talls
steals64020063stea_ls
strafes104516003strafes
strains74218153strains
straits74916323straits
strakes114218073strakes
strands83711953strands
straps87721783stra_ps
strass67117223stra_ss
stratas73013583stratas
straths102711723straths
stratus73011733stratus
straw813321293straw__
strawed114813613strawed
strawy1210312823straw_y
strays96417933stra_ys
streels73811343streels
strews96817103strew_s
strolls739183strolls
strows96718273strow_s
sucrases10310253sucrases
surahs94515543sura_hs
sural55931263sura_l_
suras55336333sura__s
swails94913123s_wails
thralls10299043thralls
thraws129211103thraw_s
trails64622513_trails
trawl84915873_trawl_
wawls115416473__wawls
yawls114613603__yawls

Search took 7 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 Limit1340272856.34321129.9
3Display Results2852850.0962968.8
 (SQL Overall)1786912856.84526105.3
 
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.