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

227 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
peroral931479(None) 
preoral9312671preoral
auroral7310472auroral
ephoral1248402ephoral
femoral1238722femoral
parral85517532par_ral
pectoral121210502pectoral
pedocal1237892pedocal
peroneal1049172peroneal
perorally1448222perorally
perorate10417922perorate
personal102311572personal
perusal939192perusal
petrosal1047152petrosal
peytral1287502peytral
premoral1249712premoral
serosal7311152serosal
sororal7310652sororal
aboral8314373_aboral
aerial64625713aer_ial
aerobat9514473aerobat
aerogel836523aerogel
aerogram1149523aerogram
aerosat7417183aerosat
aerosol747683aerosol
amoral8314633_amoral
apertural1144093apertural
approval1544483approval
aurora6411763aurora_
aurorae739663aurorae
auroras7311703auroras
begorah1355593begorah
boral75831703__boral
bromal10313653_bromal
caporal11410943caporal
central93114473central
ceorl7410923ce_or_l
ceramal1138843ceramal
cercal10314123cer_cal
cereal8315833cer_eal
cerebral1266183cerebral
chloral12169983chloral
choral115118493_choral
coral76033453__coral
coronal94115763coronal
corporal1248513corporal
corral83616253cor_ral
crural8610633_crural
deposal1037153deposal
dermal93614343der_mal
dextral1577003dextral
estral64716513_estral
federal1148533federal
fedora1038593fedora_
fedoras1137923fedoras
femora1149583femora_
feral85424653fe__ral
ferial94621253fer_ial
ferrel92810203fer_rel
floral94313813_floral
general81010933general
gooral7310463_gooral
goral65125753__goral
herbal112513493her_bal
hernial10310433hernial
heroical13410023heroical
horal86328683__horal
humoral1237973humoral
immoral1146783immoral
litoral7610763litoral
loral55927823__loral
mayoral1237693mayoral
memorial1249523memorial
menorah1247933menorah
moral75533433__moral
nerol51017813nero__l
neural6311993ne_ural
neuronal846893neuronal
neurosal845833neurosal
neutral737923neutral
nonoral7313603nonoral
oral47638123___oral
pakora1247283pakora_
pakoras1337473pakoras
papyral1445773papyral
parfocal1565393parfocal
parol74826273paro__l
parrals94414573par_rals
parrel84515983par_rel
partial92616263partial
parura8310583parura_
paruras9310533paruras
pastoral10310483pastoral
patronal1048653patronal
peal68648103pe___al
pearl75324463pe_ar_l
pectorals13128153pectorals
pedal86022503pe__dal
pedocals1346083pedocals
peloria9310953peloria
pelorian1048883pelorian
pelorias10410593pelorias
peloric11310713peloric
pelorus939273pelorus
pelota8612833pelota_
pelotas9410723pelotas
penal75228373pe__nal
penial84120893pe_nial
perborate13510143perborate
percale11314093per_cale
perea75026443per_ea_
pereia85217983pereia_
perforate1459463perforate
perforce1544963perforce
perform1439283perfor_m
performs1547483performs
pergola1067623pergola_
pergolas1158233pergolas
pericopal1545813pericopal
peridial11411923peridial
perigeal1147553perigeal
peril75425953pe__ril
perilla9311233perilla
perineal1049193perineal
permian112612283permian
perorated12412463perorated
perorates11417023perorates
perorator1149743perorator
peroxid17310273peroxid
peroxy1838253pero_xy
perron83216623per_ron
perrons93115483perrons
perry105222713per_r_y
persalt9315413per_salt
persona92812453persona_
personae102410553personae
personals11238573personals
personas102511883personas
perusals1047143perusals
petal76526893pe__tal
petrale9312623pe_trale
petrel83111533pe_trel
petrol82714063pe_trol
petronel1048143petronel
peyotl1146233peyo_tl
peytrals1355493peytrals
peytrel1264253peytrel
phonal11310383p_honal
phrasal1246163phrasal
phratral1344373phratral
piperonal1344733piperonal
pivotal1245433pivotal
pleonal937243pleonal
pleural956673pleural
plural839823p_lural
portal84218463por_tal
portray1237483portray
postoral10311723postoral
preanal9310713preanal
predial103815413predial
premeal11310523premeal
prerenal1049083prerenal
pretorial11512653pretorial
pretrial10511983pretrial
prewrap14104973prewrap
primal104014623p_rimal
proa66229963p_ro_a_
proas75028803p_ro_as
procural1246923p_rocural
program12311693p_rogram
prolan8414693p_rolan
propel103714063p_ropel
propyl13358183p_ropyl
prorate9418733p_rorate
protyl11308213p_rotyl
proviral1346493p_roviral
prowar114110943p_rowar
prowl105615123p_ro_wl
puberal1147773puberal
puerperal1342803puerperal
pyrola1139003pyrola_
pyrolas1239863pyrolas
pyrrol1136273pyr_rol
recoal84117973reco_al
remora8414593remora_
remoras9314073remoras
removal1236733removal
reposal939113reposal
reproval1355773reproval
reroll6412683rero_ll
restoral8810983restoral
retotal739843retotal
retral64419743re_tral
royal85014703__royal
rural55821173__rural
scrotal938493scrotal
seconal9310073seconal
sectoral10109543sectoral
senora63216163senora_
senoras72714953senoras
seral56336383se__ral
serial64625863ser_ial
serosa6313023serosa_
serosae7310243serosae
serosas7312663serosas
serovar1046143serovar
serumal938783serumal
serval93913413ser_val
several1039533several
spectral12246193spectral
sporal82915453_sporal
stromal93010593stromal
suboral92011993suboral
sudoral8148543sudoral
temporal1246333temporal
tergal72912833ter_gal
terra54419663ter_ra_
terrae62915213ter_rae
terras63516973ter_ras
tertial7313863tertial
tumoral938133tumoral
unmoral948693unmoral
ventral103612173ventral
verbal112513663ver_bal
vernal93514213ver_nal
versal93013753ver_sal
vestral104111013vestral

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.440406115.9
2DLD Change Limit1340272276.92019368.1
3Display Results2272270.0802837.5
 (SQL Overall)1786912277.44024017.6
 
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.