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

461 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
parrals9441457(None) 
parral85517531parral_
parrels94713491parrels
argals75517712_argals
arras55626132_arra_s
arrays95311682_arrays
barrels94514362barrels
carpals113414622carpals
carrels95117302carrels
corrals93713852corrals
farfals13268502farfals
hartals10313022hartals
jarrahs1735452jarrahs
marrams11310122marrams
narwals1036982narwals
paras76143042pa_ra_s
parcels113712662parcels
pardahs13289672pardahs
pariahs123812342pariahs
parians93519732parians
parkas125018022parka_s
parlays123910452parlays
parols84722612pa_rols
parrel84515982parrel_
parries93925842parries
parrots9312742parrots
parrs75928672parr__s
partans94418282partans
partials101911952partials
paruras9310532parura_s
pascals11610012pascals
patrols93513512patrols
plurals936912plurals
portals94015562portals
pyrrols1235402pyrrols
sacrals93311792sacrals
tarsals72512602tarsals
aals49941143_a__als
aerials74017553aerials
annals66415923_annals
apicals1159923apicals
appals104812943_appals
appeals11378673appeals
araks94820883_a_raks
areal55928733_areal_
areas55935773_area_s
argal65023393_argal_
argala74712673_argala
argalas84011093_argalas
argali75013753_argali
argalis84214193_argalis
argils75213623_argils
argols74514613_argols
arhats9312973_arhats
arias55438023_aria_s
ariels65119373_ariels
arils58732203_a_rils
arrack121110253_arrack
arracks1387733_arracks
arrant6623253_arrant
arrases71214543_arrases
array86317143_arra_y
arrayals1154483_arrayals
arrears738843_arrears
arris56824683_arr_is
arrivals1145933_arrivals
arrows92813483_arrows
artal55525473_artal_
artels66216233_artels
arval86017013_arval_
aryls87015813_a_ryls
astrals75515243astrals
aural54428963_aural_
auras55932563_aura_s
baals76122703ba__als
barbal104016663barbal_
barbels114514433barbels
barcas101016603barca_s
barrable1249243barrable
barrack1538253barrack
barracks1636883barracks
barrage10710843barrage
barrages11711083barrages
barrel84517873barrel_
barrens94414323barrens
barres84427543barr_es
barrets94917103barrets
barrios9310773barrios
barrows123411683barrows
bharals1236733bharals
borals86721913_borals
burials93612083burials
cabals104020153ca_bals
canals84421663ca_nals
cantals93919573cantals
caporals1238923caporals
caracals12310753caracals
carats85929023ca_rats
carcass11310513carcass
carcels114516063carcels
carfuls1249133carfuls
carls77037423ca_r_ls
carnal83919203carnal_
carols85124983ca_rols
carpal103716253carpal_
carpale113414353carpale
carpels115315463carpels
carrack1548753carrack
carracks1637713carracks
carrel84718633carrel_
carrell94610473carrell
carrells10359273carrells
carries94328013carries
carroms11512403carroms
carrots9714623carrots
carrs75730853carr__s
carryall1343913carryall
carryalls1443523carryalls
cartels94618123cartels
carvels124914593carvels
casuals91410523casuals
causals91411183causals
cereals9313173cereals
chaparrals1751543chaparrals
chorals124614113chorals
citrals91111673citrals
corals85325143_corals
corral83616253corral_
craals84113303_craals
currans9310613currans
curtals93111623curtals
darbars10510093darbars
darnels83710433darnels
dorsals84110843dorsals
durras74713373durra_s
earfuls1036863earfuls
earlaps936393earlaps
earls56127513ea_r_ls
facials123310743facials
fallals103310193fallals
farads104713273fa_rads
fardels11389893fardels
farfal123410183farfal_
farfels13348213farfels
farls85731113fa_r_ls
farrago1144923farrago
farrows13259783farrows
faucals12326563faucals
ferals94216643_ferals
ferrels10248623ferrels
florals104210063florals
formals123312893formals
garrets84413623garrets
garrons82713463garrons
gavials1136603gavials
gayals1039513ga_yals
gharials1245123gharials
goorals838703goorals
gorals76917653_gorals
graals74112913_graals
halals95018313ha_lals
hamals114816823ha_mals
hammals14409223hammals
harass9313943ha_rass
hardass1139753hardass
harls85634503ha_r_ls
harries103525493harries
harrows132611033harrows
hartal9415473hartal_
herbals122710603herbals
hurrahs13336773hurrahs
hurrays13386153hurrays
jacals1539873ja_cals
jackals2036893jackals
jagras1438463jagra_s
jarfuls1754773jarfuls
jarls126120963ja_r_ls
jarrah1636683jarra_h
karats106420493ka_rats
karmas123013733karma_s
karroos1139313karroos
kraals10378433_kraals
labials9299873labials
lariats7615053lariats
larrups934733larrups
larval948503larval_
larvas9310233larva_s
laterals8312753laterals
lauras63414333laura_s
laurels746663laurels
madras94316433madra_s
mammals10389273mammals
manuals9311213manuals
maras75443293ma_ra_s
marcels113212373marcels
margays1337493margays
markas124717003marka_s
marls75535163ma_r_ls
marram10313883marra_m
marrano939423marrano
marranos1038423marranos
marrers93414313marrers
marries93825283marries
marrons93216973marrons
marrows122911823marrows
marsala939583marsala
marsalas1038253marsalas
marshals1337783marshals
marvels123810093marvels
matrass939403matrass
morals85324633_morals
mortals93914003mortals
murals84016763_murals
murras84916013murra_s
nairas6312783naira_s
narial6317953narial_
narrate7313493narrate
narrates8312763narrates
narrows10258843narrows
narwal938943narwal_
narwhals1443613narwhals
nasals63312463na_sals
naturals847903naturals
normals92510903normals
orals55826483__orals
pacas96029403pa_ca_s
pachas135017143pacha_s
padnags1135083padnags
padres95016983padr_es
paeans85118263pa_eans
paellas9411413paellas
paesans93312693paesans
pagans95717923pa_gans
pails75833063pa__ils
pairs75325833pair__s
paisans93614753paisans
paisas84317493paisa_s
pakoras1337473pakora_s
palais8420423pa_lais
palatals1037773palatals
paleal84716673paleal_
palls74332563pa__lls
palpal104112053palpal_
pals66951353p___als
pampas124913993pampa_s
pandas95521963panda_s
panels84716523pa_nels
panfuls1237173panfuls
pangas99921103panga_s
pangrams1337153pangrams
papal95820673pa_pal_
papas94927493pa_pa_s
papaws13419113pa_paws
papyral1445773papyral_
para65242173pa_ra__
parable111819773parable
parables121613563parables
parade94720643pa_rade
parades104121463parades
parados103816053parados
parae76335703pa_ra_e
paralyse1347483pa_ralyse
paramo102614643pa_ramo
paramos113213513paramos
parang93715513pa_rang
parangs104314373parangs
paraph13311263pa_raph
paraphs1439313paraphs
parasails1147583parasails
parasols1039263parasols
parbake1538353parbake
parbakes1638343parbakes
parboils1237433parboils
parcel103915473parcel_
parches143720003parches
pardah123412823parda_h
pardons103817623pardons
pards85634333pa_r_ds
pareiras1038183pareira_s
parents93418123parents
pareos87023773pa_reos
parers85530743pa_rers
pares77164483pa_r_es
pareses94718883pareses
paresis93315093paresis
pareus85420743pa_reus
parfait12312053parfait
parfaits1346913parfaits
parges94529543pa_rges
pargets105215193pargets
pargos95719043pa_rgos
pariah114320583paria_h
parian83223963paria_n
paries84742513pa_ries
parietals1146863parietals
parings104219213parings
paris75145943pa_r_is
parises94827183parises
parka115120883parka__
parkade1437583parkade
parkades1538273parkades
parkers133816873parkers
parks116134463pa_r_ks
parkways2043973parkways
parlay113713993parla_y
parle75836163pa_r_le
parles86334403pa_rles
parleys125212373parleys
parlors9312913parlors
parlous9414293parlous
parodos103011753parodos
parol74826273pa_rol_
parole84425253pa_role
paroles95025883paroles
parous84024163pa_rous
parr65731153parr___
parred95024073parr_ed
parried103615723parried
parrier93717653parrier
parriers103612903parriers
parring103222063parring
parrot8320663parr_ot
parroty1247863parroty
parry105323753parr__y
pars67560793pa_r__s
parsable12311693parsable
parsecs11429923parsecs
parsers94118153parsers
parses85534703pa_rses
parsons93516873parsons
partake1339643partake
partakes1449923partakes
partan83820563parta_n
partial92616263partial_
parties93230863parties
partly116315473pa_rtly
partons94620513partons
parts77743373pa_r_ts
parura8310583parura__
parures9512693parures
parvis116114803pa_rvis
parvos116614753pa_rvos
pascal10812373pascal_
paschals1566473paschals
pashas115117063pasha_s
passels93913023passels
pastas85422873pasta_s
pastels95215183pastels
pastils94416173pastils
pastorals1147953pastorals
patrol83213023patrol_
patrons93818103patrons
pausal81511963pausal_
pavans115715593pa_vans
pawls105617663pa__wls
pawpaws1732823pawpaws
paydays1634433paydays
payolas12148973payolas
payroll1245613payroll
payrolls1344753payrolls
peals75235493p__eals
pearls84715393pear_ls
pedals94316033p_edals
percale11314093percale
percales12313803percales
perhaps1446123perhaps
perils84121853p_erils
peroral9314793peroral_
perries93226603perries
perrons93115483perrons
persalt9315413persalt
persalts1038193persalts
perusals1047143perusals
petals84719813p_etals
petrale9312623petrale
petrales10312983petrales
petrels9279373petrels
petrols92913083petrols
peytrals1355493peytrals
phials1158873p_hials
phreaks1634543phreaks
pibals103813083p_ibals
pineals93212843pineals
pipals104213643p_ipals
plural839823plural_
portal84218463portal_
portrays1345293portrays
postals93716373postals
praams10459643p_raams
prams96125513p__rams
praos74923563p__raos
prats76333393p__rats
praus74621753p__raus
prays105022433p__rays
prills84015613p_rills
proas75028803p_roa_s
prowls115511083p_rowls
purdahs13285483purdahs
purdas92612263purda_s
purls74723353p_ur_ls
purrs75320433purr__s
pyrans11411063p_yrans
pyrolas1239863pyrolas
pyrrol1136273pyrrol_
pyrrole1246033pyrrole
pyrroles1345453pyrroles
quarrels1735083quarrels
radials83614633radials
rascals959663rascals
ratals64219583ra_tals
reals55038653__reals
rials55026673__rials
sabals84618863sa_bals
sabras85116363sabra_s
sacral83414413sacral_
safrols1036863safrols
salals65120083sa_lals
sambals115213483sambals
sandals82715203sandals
sarans64224433sa_rans
sardars83112903sardars
sarsars73512143sarsars
satraps95011643satraps
saurels749303saurels
serials73919743serials
servals103410743servals
sirrahs10377303sirrahs
sirras63814863sirra_s
sorrels7310723sorrels
sparrows1344803sparrows
spirals93212513spirals
sporrans1045523sporrans
surras65919533surra_s
tagrags936123tagrags
tamals84116633ta_mals
tarmacs1138323tarmacs
tarnal63716503tarnal_
tarpans92513533tarpans
tarres64723043tarr_es
tarries73324263tarries
tarsal63315273tarsal_
tartans72615823tartans
tartars73313403tartars
tarzans16329923tarzans
terras63516973terra_s
trials64319883_trials
urials64415193_urials
vandals113211663vandals
varas86028193va_ra_s
varias95019903varia_s
varnas94212823varna_s
vassals1057953vassals
verbals121910743verbals
wadmals1335513wadmals
warragals1343473warragals
warrant10614243warrant
warrants1168503warrants
warrens103810893warrens
warrigals1343773warrigals
warsaws1335763warsaws
yarrows13277853yarrows

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 Limit1340274616.89019452.4
3Display Results4614610.2202095.5
 (SQL Overall)1786914617.51623774.7
 
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.