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

365 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
scrawl1120808(None) 
crawl104916711_crawl
scrawls12177271scrawls
scrawly15197181scrawly
sprawl11188061sprawl
becrawl1444582becrawl
brawl106217962_brawl
craal74117752_craal
craw97725262_craw_
crawls114712082_crawls
crawly144610762_crawly
craws105723122_craws
drawl95516012_drawl
sacral83414412sacra_l
scall74420372sc_all
scowl1012012972sc_owl
scrag85916172scra_g
scrags95713802scrags
scram910621612scra_m
scrams105216622scrams
scrap97120402scra_p
scrape105917572scrape
scraps106017242scraps
scrawled1445902scrawled
scrawler1345882scrawler
scrawny15213932scrawny
screw109318532screw_
screws115513882screws
screwy14659452screwy
scroll8310162scroll
serail64222672serail
seral56336382sera_l
shawl116217572s_hawl
sprawls12176372sprawls
sprawly15166042sprawly
straw813321292straw_
straws98718672straws
strawy1210312822strawy
sural55931262sura_l
trawl84915872_trawl
astral66919283astra_l
aural54428963aura_l
awl67635303___awl
bawl95326063__bawl
becrawls1543623becrawls
boral75831703bora_l
brail75525553_brail
braw94829563_braw_
brawls115214333_brawls
brawly144312353_brawly
brawn106018563_brawn
braws106425193_braws
call66838673_c_all
carl65144783_c_arl
carol75128613_carol
caul65630003_c_aul
caw86647933_c_aw_
caws96036103_c_aws
chaw126224633_chaw_
chaws135022463_chaws
claw95624343_claw_
claws106020833_claws
coal66939253_coa_l
coral76033453cora_l
cowl97530813_c_owl
craals84113303_craals
crab85727673_cra_b
crabs95421393_crabs
crack134120533_crack
cradle93313163_cradle
craft105327663_craft
crag75625303_cra_g
crags85622573_crags
crake114823523_crake
cram85635493_cra_m
cramp115120693_cramp
crams96229153_crams
crane75331603_crane
crank114819613_crank
crap85731843_cra_p
crape96128443_crape
craps95328643_craps
crash109120013_crash
crass76328043_crass
crate76537403_crate
crave105626313_crave
crawled133710393_crawled
crawler123510453_crawler
craze165221463_craze
crazy195511223_crazy
creel75121483_creel
crew96122673_crew_
crewel114310473_crewel
crews105917493_crews
crow96428133_crow_
crowd115815623_crowd
crown105620083_crown
crows105727313_crows
cruel74815903_cruel
derail74218813derail
drail65020973_drail
draw85623013_draw_
drawls105511393_drawls
drawly134910723_drawly
drawn95614243_drawn
draws95119373_draws
dural64923893dura_l
escrow1135913escrow_
escrows1235803escrows
estral64716513estra_l
feral85424653fera_l
frail85220213_frail
goral65125753gora_l
graal64316503_graal
grail64622873_grail
growl96115823_growl
gyral94412783gyra_l
horal86328673hora_l
jural125120483jura_l
kraal94511823_kraal
loral55927823lora_l
moral75533433mora_l
mural75225103mura_l
narwal938943narwal
octal71214723octa_l
oral47638123_ora_l
outcrawl1344583outcrawl
pawl95123263__pawl
prawn105312433_prawn
prowl105615123_prowl
rail46147763__rail
raw67252253__raw_
rawly115115833__rawly
raws75238213__raws
rural55821173rura_l
sabal75422483saba_l
sacra74516993sacra__
sacrals93311793sacrals
sail45447163s__ail
sal36462883s__a_l
salal55425703sala_l
sall44544683s__all
saran53730303sara_n
sarans64224433sarans
sarape84817573sarape
saul45836523s__aul
saw68255353s__aw_
sawn75428163s__awn
saws75839483s__aws
scab85926713sc_a_b
scabs94818643sc_abs
scad75725763sc_a_d
scads85419953sc_ads
scag76626893sc_a_g
scags85520973sc_ags
scald84818123sc_ald
scale74629143sc_ale
scalls84218203sc_alls
scalp95217983sc_alp
scaly104718723sc_aly
scam85932353sc_a_m
scamp115717313sc_amp
scams94423973sc_ams
scan65530453sc_a_n
scans74625103sc_ans
scant79735073sc_ant
scape96921843sc_ape
scar66434203sc_a_r
scarab10310063scarab
scarabs1137293scarabs
scarce104013633scarce
scare75334463sc_are
scared95227293scared
scarer84524603scarer
scares85033003scares
scarey115016983scarey
scarf105427143sc_arf
scarfs114714683scarfs
scarily12311703scarily
scarp95724103sc_arp
scarph13429603scarph
scarps104718603scarps
scarry116311183scarry
scars75433533sc_ars
scart76139773sc_art
scarts85321493scarts
scary105222593sc_ary
scat65848373sc_a_t
scats75930603sc_ats
scatt76030093sc_att
scaup95515993sc_aup
scaur75814903sc_aur
schav1338313scha_v
schavs1436493schavs
school11410723school
schorl1179803schorl
schul102510413sc_hul
schwa13426843sc_hwa
schwas14396983schwas
sclaff1438313sclaff
scleral937863sclera_l
scow96021423sc_ow_
scowls11549593sc_owls
scows106617803sc_ows
scrabble14196993scrabble
scrabbly17164623scrabbly
scraggly15294143scraggly
scraggy14304583scraggy
scraich1436763scraich
scraigh1335673scraigh
scramble14177253scramble
scrannel1044033scrannel
scraped124313133scraped
scraper114513403scraper
scrapes116217663scrapes
scrapie115010943scrapie
scrapple1434683scrapple
scrappy16234473scrappy
scratch1446013scratch
scrawlers1434743scrawlers
scrawlier1443893scrawlier
scrawling15195573scrawling
screak125311053screak
screaks13469353screaks
screaky16436213screaky
scream104814243scream
screams114810613screams
scree720031703scr_ee
screed95718923screed
screen85216013screen
screes85023963screes
screwed135710653screwed
screwer124410063screwer
screwup1442963screwup
scribal1137963scribal
scribe104613523scribe
scried95817303scried
scries85226823scries
scrim95419723scr_im
scrimp125110583scrimp
scrims104615933scrims
scrip96619193scr_ip
scrips105316033scrips
script105717903script
scrive115414943scrive
scrod85115063scr_od
scrods94111603scrods
scrolls938063scrolls
scroop10299773scroop
scrota8310183scrota
scrotal938483scrotal
scrub94914203scr_ub
scrubs104210313scrubs
scruff1437963scruff
scrum95418193scr_um
scrums104614253scrums
scruple1137193scruple
scry96017763scr__y
scull75315763sc_ull
scurril945103scurril
seal45654373s_ea_l
sepal77723003sepa_l
sera46141393sera__
serac75925203sera_c
seracs84418573seracs
serai56830163sera_i
serails73318363serails
serais64326133serais
serape84818413serape
seraph114011163seraph
serial64625853serial
serow86720443serow_
serows96016393serows
serval93913413serval
setal56430903seta_l
shall85024053s_hall
shaul85418103s_haul
shaw108132553s_haw_
shawls125411973s_hawls
shawm135316143s_hawm
shawn116417613s_hawn
shaws116226263s_haws
sheal84927703shea_l
shoal83920263shoa_l
shrank13359123shrank
shrew119720163shrew_
shrewd136810773shrewd
shrews129313913shrews
shrill94712303shrill
sial45938833s_ia_l
sisal54217733sisa_l
skoal93811453skoa_l
slaw77930713s_law_
slaws85222713s_laws
small74016263s_mall
snail57020203s_nail
snarl54921083s_narl
snaw78923073s_naw_
snaws86116363s_naws
social8813333socia_l
sora45746913sora__
soras55041013sora_s
sorel56231443sor_el
sorrel6413543sorrel
spail74921553s_pail
spall74919303s_pall
spawn107811713s_pawn
spiral83715343spira_l
sporal82915453spora_l
sprag86418693spra_g
sprags95715823sprags
sprain83614863sprain
sprang95713523sprang
sprat76635973spra_t
sprats85819933sprats
sprawled1434513sprawled
sprawler1334643sprawler
spray106720063spra_y
sprays115913643sprays
squall1537993squall
squaw17368983squaw_
squawk22385373squawk
squaws18438783squaws
stall54722353s_tall
staw78627693s_taw_
steal56125473stea_l
strafe95215973strafe
strain64919573strain
strait64025893strait
strake104017393strake
strand74514823strand
strang75718313strang
strap77925263stra_p
straps87721783straps
strass67117223strass
strata63616283strata
stratal72710603stratal
strath93216363strath
strati63518893strati
strawed114813613strawed
stray88525573stra_y
strays96417933strays
streel64214023streel
strew89220653strew_
strewn96710003strewn
strews96817093strews
stroll6311603stroll
strow88920573strow_
strown96812093strown
strows96718273strows
sucrase9310343sucrase
sura45740293sura__
surah86823253sura_h
surahs94515543surahs
suras55336323sura_s
swail86217163s_wail
thrall93810293thrall
thraw1110515923thraw_
thrawn12769423thrawn
thraws129211103thraws
trail55126773_trail
trawls94412393_trawls
viral86419593vira_l
wawl105321943__wawl
yawl104918973__yawl

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163656.70316815.8
3Display Results3653650.1103318.2
 (SQL Overall)1786913656.95325699.8
 
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.