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

429 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
stroll631160(None) 
scroll8310161scroll
strolls739181strolls
troll54416531_troll
atoll57913922at_oll
droll65415402_droll
enroll61110072enroll
outroll749302outroll
reroll6412682reroll
roll46331652__roll
scrolls938062scrolls
shrill94712302shrill
stall54722352st_all
sterol6613332stero_l
sterols7313442sterols
still54922082st_ill
stole54928812st_ole
stool55619892st_ool
stools65117022stools
streel64214022streel
strobe84513812strobe
strobil936962strobil
strode75215972strode
stroke105116172stroke
strolled937812strolled
stroller848172stroller
stroma84313072stroma
stromal93010592stromal
strong74914882strong
strook10410302strook
strop77422242stro_p
strops86220382strops
stroud7310382stroud
strove95014792strove
strow88920572stro_w
strown96812092strown
strows96718272strows
stroy87720392stro_y
stroys95914602stroys
stull54916272st_ull
toll45535262_t_oll
trill55122932_trill
trolls64613942_trolls
trolly94012362_trolly
trull54012672_trull
unroll61210072unroll
antiroll847763antiroll
astral66919283astr_al
astrally1148883astrally
astrals75515243astrals
atolls65511353at_olls
atrial65418943atrial
bedroll1055553bedroll
boll65634753__boll
brill74819953_brill
broil74918223_broil
brolly114510853_brolly
carol75128613caro_l
caroli85918233caroli
carols85124983carols
corolla938623corolla
doll56632493__doll
drill64718263_drill
drolls75312393_drolls
drolly105411673_drolly
drool65416103_drool
enrol51014283enro_l
enrolls7108093enrolls
enrols61213383enrols
enscroll1093333enscroll
estral64716513estr_al
estriol747553estriol
estriols856253estriols
estrone7413953estrone
estrous7712533estrous
estrual7367933estrual
extoll1334863extoll
frill84917563_frill
girolle835793girolle
grill64617893_grill
growl96115823_growl
inscroll10113213inscroll
knoll9389603_knoll
krill94213643_krill
logroll844263logroll
loll46128383__loll
moll66735703__moll
nerol51017813nero_l
neroli61111153neroli
nerols6914883nerols
ostiole739013ostiole
outpoll946793outpoll
outrolls847823outrolls
parol74826273paro_l
parole84425253parole
parols84722613parols
patrol83213023patro_l
patrols93513513patrols
payroll1245613payroll
petrol82714063petro_l
petrols92913083petrols
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
safrol937283safro_l
safrole1037253safrole
safrols1036863safrols
sall44544683s__all
salol55222143salo_l
salols64017873salols
sarod65325873saro_d
sarode75317513sarode
sarods74918573sarods
sarong73914873sarong
saros55238063saro_s
scall74420373s_call
school11410723school
schorl1179803schorl
scold85414863s_cold
scowl1012012973s_cowl
scrawl11208083scrawl
scrod85115063scro_d
scrods94111603scrods
scrolled1137043scrolled
scroop10299773scroop
scrota8310193scrota
scrotal938493scrotal
scull75315763s_cull
sell45840613s__ell
serail64222673serail
seral56336383ser_al
serial64625863serial
serosa6313023serosa
serosal7311153serosal
serous65023563serous
serow86720443sero_w
serows96016393serows
serval93913413serval
shall85024053s_hall
shell84424123s_hell
sheol84318373sheo_l
sheols94614163sheols
shill85325333s_hill
shoal83920273s_hoal
shool84523153s_hool
shools94919013shools
shorl84720253s_horl
shorls94516203shorls
shrills10389933shrills
shrilly13318563shrilly
shroff1538503shroff
shroud1038773shroud
shrove125412233shrove
sill45545153s__ill
skell94915833s_kell
skill94316723s_kill
skoal93811463s_koal
skull94812033s_kull
small74016263s_mall
smell74916233s_mell
smolt74824163s_molt
snell54517303s_nell
snool55118643s_nool
snools65715883snools
soil46138833s__oil
sokol94612293soko_l
sokols10399093sokols
sol37256623s__o_l
sola45541863s__ola
sold54837413s__old
sole46053673s__ole
soli46637013s__oli
solo45538943s__olo
sols45448163s__ols
sorel56231443sor_el
sorels63921163sorels
sorely94618013sorely
sororal7310653sororal
sorrel6413553sorrel
sotol54917653soto_l
sotols63714473sotols
soul46435713s__oul
spall74919303s_pall
spell75020303s_pell
spill74821163s_pill
spoil75818653s_poil
spool75219043s_pool
spools85115913spools
sporal82915453sporal
sprawl11188063sprawl
sprout8419403sprout
spryly1435513spryly
squall1538003squall
squill1537233squill
stable83921643stable
stably113314123stably
stale55637103st_ale
stalk94518003st_alk
stalls64019933stalls
stanol6310723stanol
stanols739733stanols
staple84415823staple
starkly14277033starkly
startle72511123startle
statal61613223statal
steal56125473st_eal
steals64020063steals
steamroll1152103steamroll
steel55721993st_eel
steels64117983steels
steely93612573steely
stela54019043st_ela
stele55026843st_ele
stella63612973stella
sterile7316603sterile
sternal73411913sternal
sternly1037853sternly
steroid81314863steroid
stifle93611903stifle
stile54931573st_ile
stills64118573stills
stilly93714093stilly
stilt54831983st_ilt
stipel84412123stipel
stoa45425913st_o_a
stoae55024263st_oae
stoai55417873st_oai
stoas55126023st_oas
stoat57135953st_oat
stob66724613st_o_b
stobs75718233st_obs
stock114417563st_ock
stogy95414083st_ogy
stoic7317253st_oic
stoke94922513st_oke
stoled74521593st_oled
stolen64315063st_olen
stoles63927673st_oles
stolid74213183st_olid
stollen747583st_ollen
stolon64112073st_olon
stoma75918273st_oma
stomal85213313stomal
stomp95616663st_omp
stone55431183st_one
stony85818643st_ony
stood65517713st_ood
stooge73811663stooge
stook95218213st_ook
stooks105115373stooks
stooled84313893stooled
stoolie739723stoolie
stoop75821543st_oop
stoops85917893stoops
stop66532033st_o_p
stope74727243st_ope
stops74827283st_ops
stopt76528353st_opt
storax1389783storax
store56333813st_ore
stored75524213stored
storer64721673storer
stores65533663stores
storey95217613storey
stork96819693st_ork
storks106115953storks
storm76520393st_orm
storms85814633storms
stormy115510733stormy
story86723033st_ory
stoss54316343st_oss
stot46347333st_o_t
stots54828553st_ots
stott56929793st_ott
stoup75517073st_oup
stour54916743st_our
stout57434053st_out
stove85220253st_ove
stow77325743st_o_w
stowp105614233st_owp
stows86622703st_ows
strafe95215983strafe
strain64919573strain
strait64025893strait
strake104017393strake
strand74514823strand
strang75718313strang
strap77925263str_ap
straps87721783straps
strass67117223strass
strata63616283strata
stratal72710603stratal
strath93216373strath
strati63518903strati
straw813321293str_aw
straws98718673straws
strawy1210312823strawy
stray88525573str_ay
strays96417933strays
streak104613623streak
stream84717283stream
streek104111413streek
streels73811343streels
street64125773street
strep77120853str_ep
streps86218063streps
stress66616673stress
strew89220653str_ew
strewn96710003strewn
strews96817093strews
stria55723213str_ia
striae65422273striae
strick124813203strick
strict84821043strict
stride75420963stride
strife95318363strife
strigil837263strigil
strike105619733strike
string75327563string
strip77524343str_ip
stripe85822443stripe
strips85719653strips
stript85222193stript
stripy115812743stripy
strive95020963strive
strobes93813263strobes
strobic1138253strobic
strobila1044933strobila
strobile1047033strobile
strobili1044933strobili
strobils1046563strobils
stroked124613623stroked
stroker114113523stroker
strokes114316323strokes
strollers937543strollers
strolling10238793strolling
strongly1245953strongly
strongyl1243553strongyl
strophe1239143strophe
stroppy14205093stroppy
strouds837803strouds
strowed115312143strowed
stroyed114110863stroyed
stroyer103510783stroyer
struck12489263struck
strudel835783strudel
strum75619453str_um
struma84313273struma
strums84716453strums
strung75213023strung
strunt64918913strunt
strut56030733str_ut
struts65616803struts
studly10397693studly
stulls63912983stulls
style85519363st_yle
styli83911173st_yli
sural55931263sur_al
surely93816463surely
surly85124433sur_ly
swell84815983s_well
swill83417373s_will
tall47240213_t_all
tell44934703_t_ell
thill85918733_thill
thole85620843_thole
thrall93810293thrall
thrill94910593thrill
till45941203_t_ill
toil46536283_t_oil
tola45236333_t_ola
told56132203_t_old
tole46052903_t_ole
tolls54728433_t_olls
tolu45529153_t_olu
tolyl84710093_t_olyl
tool46735683_t_ool
tools55325243_tools
trail55126773_trail
trawl84915873_trawl
trial54926353_trial
trills64319853_trills
triol55521363_triol
triols66117803_triols
troak95213573_troak
trock114817603_trock
trod57627953_tro_d
trode65322853_trode
trog57628213_tro_g
trogs67022603_trogs
trois57226093_trois
troke94821053_troke
trolled84312263_trolled
troller73913173_troller
trolley10328753_trolley
trollop944793_trollop
tromp95815803_tromp
trona54118953_trona
trone55131863_trone
troop76417533_troop
trooz145016153_trooz
trop66833303_tro_p
trope75725803_trope
trot46351313_tro_t
troth85622203_troth
trots56629943_trots
trotyl9236673_trotyl
trout57332573_trout
trove85221923_trove
trow78031423_tro_w
trowel94211463_trowel
trows88826183_trows
troy77429683_tro_y
troys86418613_troys
trulls64110283_trulls
truly84111553_truly
twill85612723_twill
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 Limit1127164295.89319127.1
3Display Results4294290.1233487.8
 (SQL Overall)1786914296.15629027.1
 
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.