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

283 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
scrolls93806(None) 
scroll8310171scroll_
strolls739181strolls
drolls75312392_drolls
enrolls7108092enrolls
enscrolls1192522enscrolls
inscrolls11112482inscrolls
rerolls739942rerolls
rolls55326232__rolls
scalls84218202sc_alls
schools1249112schools
schorls1248352schorls
scolds95011232sc_olds
scowls11549592sc_owls
scrawls12177282scrawls
scrods94111612scro_ds
scrolled1137052scrolled
scroops11288252scroops
sculls84613882sc_ulls
shrills10389932shrills
stroll6311602stroll_
trolls64613942_trolls
unrolls797792unrolls
acerolas1048053acerolas
across8312643acro_ss
atolls65511353_atolls
bedrolls1144673bedrolls
bolls75531313__bolls
brills84916293_brills
broils84114173_broils
brolly114510853_brolly
calls75634733_c_alls
carols85124983caro_ls
carolus94612603carolus
cells75428063_c_ells
ceorls848163_ceorls
chills114717703_chills
cholas114818003_cholas
cholla113911023_cholla
chollas123811353_chollas
cholos114716853_cholos
coals76129603_c_oals
coils75030083_c_oils
colas75436773_c_olas
colds85726973_c_olds
coles76055063_c_oles
colly104926773_c_olly
cols66553083_c_o_ls
colts76633293_c_olts
coolly114811393_coolly
cools75632633_c_ools
corals85325143_corals
corolla938623corolla
corollas1039213corollas
cowls106922213_c_owls
craals84113303_craals
crawls114712083_crawls
creels84416943_creels
creoles9913323_creoles
criollo943953_criollo
criollos1043713_criollos
croaks125812983_croaks
crocks145118423_crocks
crocs95722433_cro_cs
crocus104813173_crocus
crofts114910593_crofts
crones84729243_crones
crooks124914413_crooks
croons85418423_croons
crops96125233_cro_ps
crores86121163_crores
cross75124503_cro_ss
croups104312553_croups
crowds124910763_crowds
crowns115615113_crowns
crows105727313_cro_ws
crozes174417663_crozes
culls75425813_c_ulls
dolls66126923__dolls
drills74414203_drills
droll65415403_droll_
drolly105411673_drolly
drools74412813_drools
enroll61110073enroll_
enrols61213383enro_ls
enscroll1093333enscroll_
escaroles1145273escaroles
escrows1235803escro_ws
extolls1444603extolls
frills94414223_frills
girolle835793girolle
girolles935523girolles
grills74314803_grills
growls104711113_growls
inscroll10113213inscroll_
jackrolls2252483jackrolls
knolls10367413_knolls
krills104211283_krills
logrolls943373logrolls
lolls512121733__lolls
molls75129783__molls
nerolis71012773nerolis
nerols6914883nero_ls
outrolls847823outrolls
paroles95025883paroles
parols84722613paro_ls
payrolls1344753payrolls
polls74627723__polls
prills84015613_prills
proles84627203_proles
prowls115511083_prowls
pyrolas1239863pyrolas
quolls15327303_quolls
repolls939053repolls
reroll6412683reroll_
rills55032713__rills
roils54826793__roils
roles56747983__roles
rolfs84817123__rolfs
roll46331653__roll_
rotls55620163__rotls
sacrals93311793sacr_als
safroles1136933safroles
safrols1036863safro_ls
salols64017873salo_ls
sarodes84216143sarodes
sarods74918573saro_ds
sarongs84511803sarongs
saros55238063saro__s
saroses73619333saroses
scalds94813693sc_alds
scales84529313sc_ales
scall74420373sc_all_
scalps104315233sc_alps
scholar1236953scholar
scholars1336683scholars
scholia1237833scholia
school11410723school_
schorl1179813schorl_
schrods1337433schro_ds
schuls11299853sc_huls
scilla8310943sc_illa
scillas9310473scillas
sciolism1247093sciolism
sciolist10410233sciolist
scions82612243scio_ns
scoffs14347503sc_offs
scold85414863sc_o_ld
scolex1538243sc_olex
scollop11275433sc_ollop
scollops12235703sc_ollops
scones84521303sc_ones
scoops105414363sc_oops
scoots85315943sc_oots
scopes104719593sc_opes
scops95820193sc_o_ps
scorers94115323scorers
scores84725923sc_ores
scorns85713023sc_orns
scots74025913sc_o_ts
scours84913593sc_ours
scouts84817943sc_outs
scowl1012012973sc_owl_
scows106617803sc_o_ws
scrags95713803scr_ags
scrams105216623scr_ams
scrapes116217663scrapes
scraps106017243scr_aps
scrawl11208093scrawl_
scrawly15197193scrawly
screaks13469363screaks
screams114810623screams
screeds106210293screeds
screens95212183screens
screes85023973scr_ees
screws115513893scr_ews
scribes113713203scribes
scries85226823scr_ies
scrimps13517903scrimps
scrims104615933scr_ims
scrips105316033scr_ips
scripts11509373scripts
scrives124414273scrives
scrod85115073scro__d
scrofula1363383scrofula
scrofulas1453503scrofulas
scroggy14243843scroggy
scrolling12187803scrolling
scrooch1444963scrooch
scrooge1037183scrooge
scrooges1137163scrooges
scroop10299783scro_op
scrota8310203scro_ta
scrotal938493scrotal
scrotum1145133scrotum
scrotums1243973scrotums
scrouge1036353scrouge
scrouges1136683scrouges
scrubs104210313scr_ubs
scruffs1554173scruffs
scrums104614253scr_ums
scruple1137193scruple
scruples1237433scruples
sculks123610263sc_ulks
scull75315763sc_ull_
sculps104611753sc_ulps
sells55134433s__ells
serails73318363serails
serials73919743serials
serosas7312663serosas
serous65023563sero_us
serows96016393sero_ws
servals103410743servals
shells94319523s_hells
sheols94614163sheo_ls
shills94519613s_hills
shoals94215793s_hoals
shools94919013s_hools
shorls94516203s_horls
shrill94712303shrill_
shrilly13318563shrilly
shroffs1634363shroffs
shrouds1136023shrouds
sills55135993s__ills
skells105013783s_kells
skills104313923s_kills
skoals10438243s_koals
skulls10429643s_kulls
smalls84514123s_malls
smells83914743s_mells
smolts84411883s_molts
snells64614203s_nells
snools65715883s_nools
soils55327983s__oils
sokols10399093soko_ls
soles55547923s__oles
solos54830793s__olos
sols45448163s__o_ls
solus54726983s__olus
sorels63921163sor_els
soroses73117483soroses
sorosis72611973sorosis
sorrels7310723sorrels
sotols63714473soto_ls
souls55127363s__ouls
spalls84217343s_palls
spells84617683s_pells
spills84717463s_pills
spoils84614533s_poils
spools85115913s_pools
sprawls12176373sprawls
sprouts949983sprouts
squalls1647313squalls
squills1666313squills
stalls64019933s_talls
sterols7313443stero_ls
stills64118573s_tills
stoles63927673s_toles
stools65117023s_tools
streels73811343streels
strobes93813263strobes
strobils1046563strobils
strokes114316323strokes
strolled937813strolled
stroller848173stroller
strollers937543strollers
strops86220383stro_ps
strouds837803strouds
strows96718273stro_ws
stroys95914603stro_ys
stulls63912983s_tulls
sucroses1039933sucroses
surplus936793surplus
swells93913983s_wells
swills94213363s_wills
thralls10299043thralls
thrills10398783thrills
tolls54728433__tolls
trills64319853_trills
troll54416533_troll_
trolly94012363_trolly
trulls64110283_trulls
unroll61210073unroll_

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 Limit1340272837.14018771.3
3Display Results2832830.1102572.7
 (SQL Overall)1786912837.65623340.0
 
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.