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

176 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
perilla931123(None) 
perillas10310831perillas
barilla9310332barilla
cedilla1036342cedilla
gorilla836972gorilla
guerilla943792guerilla
megilla1036272megilla
papilla11127912papilla
pergola1067622pergola
peridia10312372peridia
peril75425952peri_l_
periled10316322periled
perilled11410112perilled
perils84121852peri_ls
perinea9313042perinea
prill74117942p_rill_
prills84015612p_rills
spirilla1045072spirilla
vexilla1744662vexilla
zorilla1646022zorilla
aerial64625713aerial_
aerially11911913aerially
aerials74017553aerials
aerily93017013aeri_ly
ancilla948603ancilla
armilla936993armilla
aspergilla1362193aspergilla
axilla13289573_axilla
barillas10310203barillas
brill74819953_brill_
brillo84211003_brillo
brills84916293_brills
cabrilla1245833cabrilla
cedillas1145743cedillas
cella75420313ce__lla
ceria75125363ceri__a
corolla938623corolla
drill64718263_drill_
drills74414203_drills
eerily92913563eeri_ly
erica7316543_eri_ca
evilly1236593_evilly
fella84918653fe__lla
feria85922713feri__a
ferial94621253ferial_
ferula93011173fer_ula
fibrilla1364373fibrilla
frill84917563_frill_
frills94414223_frills
frilly124111443_frilly
gerbille1144613gerbille
gorillas946373gorillas
grill64617893_grill_
grille74315743_grille
grills74314803_grills
guerillas1043403guerillas
guerrilla1051883guerrilla
hemiola12107003hemiola
hydrilla1543473hydrilla
krill94213653_krill_
krills104211283_krills
latilla737953latilla
manilla93012473manilla
maxilla16248193maxilla
medulla1044713medulla
megillah1443233megillah
megillas1145893megillas
opercula1244993opercula
paella8410923p_aella
papillae12137023papillae
papillar1296733papillar
parallax1745653parallax
patella938963patella
peculia1147133peculia
pedicle1238973pedicle
penally121111773penally
penial84120893penial_
penile82219603peni_le
pepla9312863pe__pla
percale11314093percale
perea75026443per__ea
pereia85217983per_eia
pergolas1158233pergolas
peri65636973peri___
periapt11313413periapt
periblem1445513periblem
peridial11411923peridial
peridot10514243peridot
perigeal1147553perigeal
perigean1146353perigean
perigee101113393perigee
perigon1039853perigon
perihelia1445133perihelia
periling11316863periling
perilling12410003perilling
perilous10310693perilous
perilune1046993perilune
perineal1049203perineal
period9314983peri_od
periods10312243periods
periplasm1594983periplasm
periplast1387283periplast
perique1837523perique
peris75537073peri__s
perish114619063peri_sh
periti8319953peri_ti
peritus9311803peritus
periwig1345163periwig
perkily1637813perkily
perlite9317323perlite
permillage1552953permillage
peroral9314793peroral
perplex1836153perplex
persalt9315413persalt
persona92812453persona
pertly115312553per_tly
perusal939193perusal
petiolar1046173petiolar
petiole9311303petiole
pilea75123953p__ilea
pill65339473p__ill_
pillar8314023p__illar
pills74130973p__ills
prebill1138803prebill_
prebills1237293prebills
predella1145393predella
predrill1145933predrill_
predrills1244473predrills
prepill1147583prepill_
prilled104713003p_rilled
prima95019343p_ri_ma
primal104014623p_rimal
primly13439623p_rimly
primula1145713p_rimula
psylla1133953p_sylla
pteryla1243303pter_yla
puerile9310093pueri_le
puerilely1443403puerilely
pyrola1139003pyr_ola
rebill84713253rebill_
rebills93510623rebills
redrill857893redrill_
redrills956083redrills
refill94514053refill_
refills103711423refills
reroll6412683reroll_
rerolls739943rerolls
rill45140913__rill_
rille55728733__rille
rills55032713__rills
scilla8310943_scilla
sedilia847243sedilia
sensilla845623sensilla
serial64625863serial_
serially11912843serially
serials73919753serials
seriema938403seriema
seringa83310743seringa
shrill94712303shrill_
shrills10389933shrills
shrilly13318563shrilly
squilla1635533squilla
terrella844703terrella
thrill94910593thrill_
thrills10398783thrills
tortilla845893tortilla
trill55122933_trill_
trills64319853_trills
vanilla10238753vanilla
variola1068893variola
verily122616053veri_ly
vexillar1843463vexillar
villa85321233__villa
zorillas1745483zorillas
zorille1636673zorille
zorillo1644683zorillo

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.436409841.7
2DLD Change Limit1340271767.28318402.7
3Display Results1761760.0632793.7
 (SQL Overall)1786911767.78222962.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.