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

242 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
pyrola113900(None) 
pyrolas1239861pyrolas
parol74826272parol_
parole84425252parole
parols84722612parols
payola11208112payola
payroll1245612payroll
pergola1067622pergola
proa66229962p_ro_a
prolan8414692p_rolan
prole74527792p_role
pyro96019392pyro__
pyrone112714472pyrone
pyrope132810532pyrope
pyros105718292pyro_s
pyrrol1136272pyrrol_
pyrrole1246032pyrrole
pyrrols1235402pyrrols
acerola947833acerola
areola6813673areola
aroma71220153_aroma
arroba898663arroba
aureola747033aureola
aurora6411763aurora
bola66035563__bola
byrl95716013byr_l_
byrls105711233byr_ls
byroad1236623byroad
canola8313623canola
carol75128613carol_
caroli85918233caroli
carols85124983carols
chola104718033_chola
chroma132912473chroma
citola838393citola
cola66541393__cola
corolla938623corolla
corona83817403corona
cupola10317693cupola
cymol1287623cymol_
cymols1377193cymols
droll65415403_droll
eidola737683eidola
enrol51014283enrol_
enroll61110073enroll
enrols61213383enrols
eyra76217553eyr__a
ferula93011173ferula
gyoza1836113gy_oza
gyral94412783gyral_
gyro85217883gyro__
gyron95314623gyro_n
gyrons105511223gyrons
gyros95616483gyro_s
gyrose105310253gyrose
hyla106716513hy__la
kola85124973__kola
krona93611793_krona
mola66035633__mola
moola75117033_moola
morula8710473morula
myoma1239273my_oma
myrica1336833myrica
myrtle1135733myrtle
myxoma2043943myxoma
nerol51017813nerol_
neroli61111163neroli
nerols6914893nerols
nyala836823ny_ala
paella8410923paella
pagoda10487873pagoda
pakora1247283pakora
papula103011123papula
para65242183par__a
parabola1246663parabola
parka115120893par_ka
parlay113714003par_lay
parle75836163par_le
parlor8312683parlor
parody12410093parody
paroled104217633paroled
parolee94119653parolee
paroles95025893paroles
parous84024163parous
parral85517543parral
partly116315473partly
parura8310593parura
patrol83213023patrol_
patrols93513513patrols
payolas12148973payolas
payrolls1344753payrolls
pelota8612833pelota
pepla9312863p_epla
perea75026443per_ea
pereia85217983pereia
pergolas1158233pergolas
peril75425953peril_
perilla9311233perilla
perils84121853perils
peroral9314793peroral
peroxy1838253peroxy
persona92812453persona
pertly115312553pertly
petrol82714063petrol_
petrols92913083petrols
phyla13469183p_hyla
phytol14366563phytol_
phytols15276553phytols
pinole83218783pinole
pirana8713263pirana
piraya1167713piraya
pirog83913673piro_g
pirogi9299013pirogi
plugola1043013plugola
pol56449383p__ol_
polar75623453p__olar
pole65951303p__ole
polka11310413p__olka
poll66332133p__oll
polo66236633p__olo
pols66044563p__ols
poly96235153p__oly
pool65835953p_ool_
pools74427703p_ools
poorly1137893poorly
porose84818743porose
porous84419483porous
portal84218463portal
portly114713403portly
posole8314223posole
pozole1758913pozole
prelaw1139103p_relaw
presa74319043p_resa
prill74117943p_rill
prima95019343p_rima
pro55837263p_ro__
proas75028803p_roas
probe94320813p_robe
prod76129503p_ro_d
prods85523553p_rods
proem94818273p_roem
prof96134663p_ro_f
profs105120893p_rofs
prog75729003p_ro_g
progs86624153p_rogs
prolans9314273p_rolans
prolate9419793p_rolate
proleg94612113p_roleg
proles84627203p_roles
prolix1538683p_rolix
prolog94212973p_rolog
prom87631703p_ro_m
promo95620003p_romo
proms95426413p_roms
prone75332623p_rone
prong85218113p_rong
proof105221533p_roof
prop85932813p_ro_p
props95726883p_rops
propyla14296633p_ropyla
pros65742783p_ro_s
prose75835123p_rose
proso77222413p_roso
pross76529403p_ross
prost75434103p_rost
prosy106319253p_rosy
protea82214763p_rotea
proud84615483p_roud
prove104823193p_rove
prow97030383p_ro_w
prowar114110943p_rowar
prowl105615123p_rowl
prowls115511083p_rowls
prows106327013p_rows
proxy175011013p_roxy
pruta7314243p_ruta
psylla1133953psylla
pteryla1243303pteryla
pula65129373p__ula
purana8712933purana
purda82914693pur_da
purely114013633purely
purfle112511183purfle
purl65631423pur_l_
purls74723353pur_ls
purple102712683purple
purply13369053purply
pya87023753py___a
pyemia1337553pyemia
pyjama20303483pyjama
pylon103614003pylo_n
pylons113011243pylons
pylori1147163pylori
pyoid11513763py_oid
pyralid1347983pyralid
pyran10514473pyr_an
pyrans11411063pyrans
pyre94925553pyr__e
pyrene113210733pyrene
pyres105523883pyr_es
pyrex175211213pyr_ex
pyrexia19225463pyrexia
pyric123815073pyr_ic
pyrite11913313pyrite
pyrogen1337353pyrogen
pyrolize2248133pyrolize
pyrology17136823pyrology
pyrolyze2554143pyrolyze
pyrones123113303pyrones
pyropes142210193pyropes
pyrosis12411653pyrosis
pyrostat1347163pyrostat
pyrroles1345453pyrroles
pyrrolic1544563pyrrolic
pyuria1136953pyuria
reroll6412683reroll
role45851823__role
rolf75134873__rolf
roll46331653__roll
rota45834343__rota
rugola736293rugola
scroll8310173scroll
scrota8310203scrota
serosa6313023serosa
sola45541863__sola
spirula9257703spirula
stroll6311603stroll
stroma84313073stroma
tola45236333__tola
torula6610393torula
troll54416533_troll
trona54118953_trona
tyro76622363tyro__
tyros85118593tyro_s
unroll61210073unroll
variola1068893variola
viola85915543_viola
xylol1546133xylol_
xylols1634173xylols
yoga87418053_y_oga
yolk116218993_y_olk
zygoma2143493zygoma

Search took 6 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.373479064.3
2DLD Change Limit1127162425.45320670.5
3Display Results2422420.0962520.8
 (SQL Overall)1786912425.92230174.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.