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

350 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
scroll831016(None) 
scrolls938061scrolls
stroll6311601stroll
droll65415402_droll
enroll61110072enroll
enscroll1093332enscroll
inscroll10113212inscroll
reroll6412682reroll
roll46331652__roll
scall74420372sc_all
school11410722school
schorl1179802schorl
scold85414862sc_old
scowl1012012972sc_owl
scrawl11208082scrawl
scrod85115062scro_d
scrods94111602scrods
scrolled1137042scrolled
scroop10299772scroop
scrota8310182scrota
scrotal938482scrotal
scull75315762sc_ull
shrill94712302shrill
strolls739182strolls
troll54416532_troll
unroll61210072unroll
acerola947823acerola
acold86214923ac_old
across8312643across
atoll57913923_atoll
bedroll1055553bedroll
boll65634753__boll
brill74819953_brill
broil74918223_broil
brolly114510853_brolly
call66838673_c_all
carol75128613caro_l
caroli85918233caroli
carols85124983carols
cell65031723_c_ell
ceorl7410913_ceorl
chill105619873_chill
chola104718033_chola
cholla113911023_cholla
cholo105217973_cholo
coal66939253_c_oal
coil66439653_c_oil
col59360353_c_o_l
cola66541393_c_ola
cold77338773_c_old
cole66956113_c_ole
colly104926773_c_olly
cols66553083_c_ols
colt67158243_c_olt
coly96940533_c_oly
cool66940493_c_ool
coolly114811393_coolly
cools75632633_cools
cooly105525423_cooly
coral76033453_coral
corolla938623corolla
cowl97530813_c_owl
craal74117753_craal
crawl104916713_crawl
creel75121483_creel
creole8913723_creole
criollo943953_criollo
croak115216633_croak
croc85723733_cro_c
croci95818133_croci
crock135921993_crock
crocs95722433_crocs
croft105622683_croft
crone75231333_crone
crony105918673_crony
crook115217573_crook
croon75522783_croon
crop87628633_cro_p
crops96125233_crops
crore74922863_crore
cross75124503_cross
croup95616783_croup
crow96428133_cro_w
crowd115815623_crowd
crown105620083_crown
crows105727313_crows
croze164719453_croze
cruel74815903_cruel
cull65929643_c_ull
doll56632493__doll
drill64718263_drill
drolls75312393_drolls
drolly105411673_drolly
drool65416103_drool
enrol51014283enro_l
enrolls7108093enrolls
enrols61213383enrols
enscrolls1192523enscrolls
escarole1045743escarole
escrow1135913escro_w
escrows1235803escrows
extoll1334863extoll
frill84917563_frill
girolle835793girolle
grill64617893_grill
growl96115823_growl
inscrolls11112483inscrolls
jackroll2142743jackroll
knoll9389603_knoll
krill94213643_krill
logroll844263logroll
loll46128383__loll
moll66735703__moll
nerol51017813nero_l
neroli61111153neroli
nerols6914883nerols
outroll749303outroll
parol74826273paro_l
parole84425253parole
parols84722613parols
payroll1245613payroll
poll66332133__poll
prill74117943_prill
prole74527793_prole
prowl105615123_prowl
pyrola1139003pyrola
quoll14379493_quoll
repoll8410793repoll
rerolls739943rerolls
rill45140903__rill
roil46235293__roil
role45851823__role
rolf75134873__rolf
rolls55326233__rolls
rotl45029683__rotl
sacral83414413sacr_al
sacrals93311793sacrals
safrol937283safro_l
safrole1037253safrole
safrols1036863safrols
sall44544683s__all
salol55222143salo_l
salols64017873salols
sarod65325873saro_d
sarode75317513sarode
sarods74918573sarods
sarong73914873sarong
saros55238063saro_s
scald84818123sc_ald
scale74629143sc_ale
scalls84218203scalls
scalp95217983sc_alp
scaly104718723sc_aly
scarily12311703scarily
scholar1236943scholar
scholia1237823scholia
schools1249113schools
schorls1248353schorls
schrod1247883schro_d
schrods1337433schrods
schul102510413sc_hul
schuln11256233schuln
schuls11299853schuls
scilla8310943scilla
scion72214993scio_n
scions82612233scions
scoff134413343sc_off
scolds95011233sc_olds
scolex1538243sc_olex
scollop11275433sc_ollop
scone74621833sc_one
scooch13228123scooch
scoop95617163sc_oop
scoops105414363scoops
scoot75729143sc_oot
scoots85315933scoots
scop85925523sc_o_p
scope94821483sc_ope
scops95820193sc_ops
scorch13198093scorch
score75526733sc_ore
scored94621133scored
scorer84818253scorer
scores84725923scores
scoria8513483scoria
scorn75817443sc_orn
scorns85713013scorns
scot66242603sc_o_t
scots74025903sc_ots
scour75315533sc_our
scout75031453sc_out
scow96021423sc_o_w
scowls11549593scowls
scows106617803sc_ows
scrag85916173scr_ag
scrags95713803scrags
scram910621613scr_am
scrams105216623scrams
scrap97120403scr_ap
scrape105917573scrape
scraps106017243scraps
scrawls12177273scrawls
scrawly15197183scrawly
screak125311053screak
scream104814243scream
scree720031703scr_ee
screed95718923screed
screen85216013screen
screes85023963screes
screw109318533scr_ew
screws115513883screws
screwy14659453screwy
scribal1137963scribal
scribe104613523scribe
scried95817303scried
scries85226823scries
scrim95419723scr_im
scrimp125110583scrimp
scrims104615933scrims
scrip96619193scr_ip
scrips105316033scrips
script105717903script
scrive115414943scrive
scrofula1363383scrofula
scroggy14243843scroggy
scrolling12187803scrolling
scrooch1444953scrooch
scrooge1037173scrooge
scroops11288243scroops
scrotum1145103scrotum
scrouge1036353scrouge
scrub94914203scr_ub
scrubs104210313scrubs
scruff1437963scruff
scrum95418193scr_um
scrums104614253scrums
scruple1137193scruple
scry96017763scr__y
sculk115112463sc_ulk
sculls84613883sculls
sculp95314843sc_ulp
scurril945103scurril
sell45840613s__ell
serail64222673serail
seral56336383ser_al
serial64625853serial
serosa6313023serosa
serosal7311143serosal
serous65023553serous
serow86720443sero_w
serows96016393serows
serval93913413serval
shall85024053s_hall
shell84424123s_hell
sheol84318363sheo_l
sheols94614153sheols
shill85325333s_hill
shoal83920263s_hoal
shool84523143s_hool
shools94919003shools
shorl84720243s_horl
shorls94516193shorls
shrills10389933shrills
shrilly13318553shrilly
shroff1538493shroff
shroud1038763shroud
shrove125412223shrove
sill45545153s__ill
skell94915833s_kell
skill94316723s_kill
skoal93811453s_koal
skull94812033s_kull
small74016263s_mall
smell74916233s_mell
smolt74824163s_molt
snell54517303s_nell
snool55118643s_nool
snools65715873snools
soil46138823s__oil
sokol94612283soko_l
sokols10399083sokols
sol37256623s__o_l
sola45541863s__ola
sold54837413s__old
sole46053673s__ole
soli46637003s__oli
solo45538943s__olo
sols45448163s__ols
sorel56231443sor_el
sorels63921163sorels
sorely94618003sorely
sororal7310653sororal
sorrel6413543sorrel
sotol54917643soto_l
sotols63714453sotols
soul46435713s__oul
spall74919303s_pall
spell75020303s_pell
spill74821163s_pill
spoil75818643s_poil
spool75219043s_pool
spools85115913spools
sporal82915453sporal
sprawl11188063sprawl
sprout8419403sprout
spryly1435513spryly
squall1537993squall
squill1537223squill
stall54722353s_tall
sterol6613323stero_l
sterols7313443sterols
still54922073s_till
stole54928813s_tole
stool55619893s_tool
stools65117023stools
streel64214023streel
strobe84513813strobe
strobil936953strobil
strode75215973strode
stroke105116173stroke
strolled937813strolled
stroller848163stroller
stroma84313073stroma
stromal93010583stromal
strong74914883strong
strook10410303strook
strop77422243stro_p
strops86220383strops
stroud7310383stroud
strove95014793strove
strow88920573stro_w
strown96812093strown
strows96718273strows
stroy87720393stro_y
stroys95914603stroys
stull54916273s_tull
sucrose939303sucrose
sural55931263sur_al
surely93816453surely
surly85124423sur_ly
swell84815983s_well
swill83417373s_will
thrall93810293thrall
thrill94910593thrill
toll45535263__toll
trill55122933_trill
trolls64613943_trolls
trolly94012353_trolly
trull54012673_trull
unrolls797793unrolls

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 Limit1127163506.33017806.6
3Display Results3503500.1063301.9
 (SQL Overall)1786913506.57627173.2
 
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.