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

196 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
phenols123810(None) 
phenol1149251phenol_
phenoms1437811phenoms
phenyls1534331phenyls
enols54718402__enols
phenetols1443712phenetols
phenolic1546812phenolic
phenolics1645052phenolics
phenom1339472pheno_m
phenoxy2243482phenoxy
phenyl1435322phenyl_
phonons123310252phonons
phonos114114792phono_s
phytols15276552phytols
sheols94614162she_ols
adenyls1143923adenyls
arenous7314183arenous
benzols1836673_benzols
biphenyls1951543biphenyls
chaebols1544723chaebols
chegoes1337333chegoes
chemos13311723chemo_s
chinos115018693chino_s
cineols9128853cineols
crenels93711013crenels
cresols939653cresols
diphenyls1842103diphenyls
enol45823823__enol_
enows85115493__enows
enrols61213383__enrols
ephebos1444113ephebo_s
ethanols1144333ethanols
eugenols944623eugenols
genoas74013623_genoas
genoms94412483_genoms
guenons836563guenons
heals85733463_he_als
heels85625533_he_els
heils85222193_he_ils
heinous1038853_heinous
hellos95321683_hellos
hells85032043_he_lls
helos84928063_helo_s
helots95217703_helots
henges104516463_henges
hennas94211803_hennas
henrys12366103_henrys
hens75642573_hen__s
hents87330743_hen_ts
herls85226433_he_rls
heroes94923823_heroes
herons94820543_herons
heros84930863_hero_s
hexyls1933443_hexyls
hols76946293_h__ols
honors94816793_honors
kenos95220623_keno_s
ketols104210763_ketols
lenos56024863_leno_s
metols84115773_metols
nerols6914893_nerols
paeons83915523pae_ons
panels84716523p_anels
parols84722613p_arols
patrols93513513patrols
pawnors12297203pawnors
peals75235493p_e_als
pearls84715393p_earls
pedals94316033p_edals
peels75226423p_e_els
peens76428193peen__s
peepuls1134923peepuls
pekoes124410423p_ekoes
penal75228373p_enal_
pencels113610053p_encels
pencils113011773p_encils
pends85527193p_en_ds
penes75839223p_en_es
pengos94612413p_engos
penile82219603p_enile
penis75129323p_en_is
pennis84315743p_ennis
pennons939713pennons
pens65649643p_en__s
pensils92811593p_ensils
pentyls1236523p_entyls
penult8314653p_enult
penults937123p_enults
peones83821043p_eones
peons75327183p_e_ons
peplos101211543p_eplos
pepos96620083p_epo_s
perils84121853p_erils
pernods1038483pernods
pesos77221623p_eso_s
petals84719813p_etals
petrols92913083petrols
peyotls1233633p_eyotls
phaetons1345853phaetons
phantoms1545973phantoms
pharos11312063pharo_s
phenate12412203phenate
phenates13611583phenates
phenetol1344063phenetol_
phenetole1444073phenetole
phenetoles1544153phenetoles
phenix1837133phen_ix
phenixes2035643phenixes
phenolate1447493phenolate
phenolates1547023phenolates
phenology1846993phenology
phenylic1844483phenylic
phials1158873ph_ials
phonal11310383phonal_
phones114121213phon_es
phoneys15437143phoneys
phonics143110723phonics
phonies123717513phonies
phonily1537103phonily
phono104917023phono__
phonon114012033phono_n
phons105221143ph__ons
photogs13358213photogs
photons123814433photons
photos113316643photo_s
phots105418503ph__ots
phyllos1535583phyllos
phytol14366563phytol_
phytons15319063phytons
pianos84315933piano_s
piehole12188553piehole
pieholes13168913pieholes
pignoli1045443pignoli
pignolis1146053pignolis
pineals93212843pineals
pinole83218783p_inole
pinoles93418703p_inoles
pinons86019943p_inons
pinots85920273p_inots
pistols93213983pistols
plenums1136533plenums
pleons84213343ple_ons
plexors1645423plexors
podsols1056513podsols
podzols1934683podzols
pols66044563p___ols
polyols1238493polyols
pools74427703p__ools
pornos85015253porno_s
preboils1267293preboils
precools1237703precools
premold1247863premold
premolds1345843premolds
premolt11312073premolt
prenoon9310043prenoon
preops104911943pre_ops
presold1059603presold
pretold1049083pretold
pretors9316813pretors
propenols1346343propenols
pueblos1134843pueblos
pyrrols1235403pyrrols
quinols16297243quinols
rheboks1634003rheboks
rhetors1038513rhetors
rhinos94411123rhino_s
saphenous1444873saphenous
senors63620793_senors
sheals94420643she_als
shekels1436043shekels
shells94319523she_lls
shends105313773shen_ds
sheol84318373she_ol_
sheqels1934753sheqels
shools94919013sh_ools
sphenes123013163sphen_es
sphenoid1446323sphenoid
sphenoids1544673sphenoids
stanols739733stanols
stenos63915773steno_s
sterols7313443sterols
tenons62916603_tenons
tenors63217753_tenors
theelols1144413theelols
thenal92712423thenal_
thenars10248523thenars
thens85921833then__s
thiols95112763th_iols
thymols1533843thymols
venoms114211213_venoms
venous93713193_venous
wheals124512523whe_als
wheels123811713whe_els
whenas124610463when_as
whens114618763when__s
xenons132710483_xenons

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.410435831.7
2DLD Change Limit1340271967.00019146.7
3Display Results1961960.0603266.7
 (SQL Overall)1786911967.47023921.2
 
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.