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

180 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
phenyl143532(None) 
phenol1149251phenol
phenyls1534331phenyls
adenyl1035022adenyl
biphenyl1841932biphenyl
diphenyl1742552diphenyl
hexyl1844462_hexyl
penal75228372p_enal
pentyl1138812p_entyl
phenix1837132phenix
phenols1238102phenols
phenom1339472phenom
phenylic1844482phenylic
phonal11310382phonal
phony136715442phony_
thenal92712422thenal
acetyl11396553acetyl
adenyls1143923adenyls
alanyl955483alanyl
benzyl2034163_benzyl
beryl101211673_beryl
biphenyls1951543biphenyls
chevy16479993chevy_
chewy165011903chewy_
crenel84213063crenel
cresyl1135133cresyl
deny86027123_deny_
deprenyl1442733deprenyl
diphenyls1842103diphenyls
enol45823823__enol
ethinyl1343433ethinyl
ethynyl1642123ethynyl
evenly1236993evenly
heal75645693_he_al
heel75034223_he_el
heil76328933_he_il
hell75637893_he_ll
hemal104419803_hemal
hen67555273_hen__
hence104920043_hence
henge94819833_henge
henna84414043_henna
henry114014473_henry
henrys12366103_henrys
hens75642573_hen_s
hent76656383_hen_t
hents87330743_hents
herl75834553_he_rl
hexyls1933443_hexyls
hey96741063_he_y_
keenly1336373keenly
lienal63912783lienal
nonyl849773_nonyl
openly1137123openly
panel76023623p_anel
peal68648103p_e_al
pearl75324463p_earl
pedal86022503p_edal
peel65535613p_e_el
peen65938083peen__
peened94318163peened
peens76428193peen_s
peepul1035783peepul
peery105719443peery_
pen56558843p_en__
pence94924453p_ence
pencel103812913p_encel
pencil103712973p_encil
pend75934533p_en_d
pends85527193p_ends
penes75839223p_enes
pengo84317593p_engo
penial84120893p_enial
penile82219603p_enile
penis75129323p_enis
penna74520203p_enna
penne75423853p_enne
penni74617903p_enni
penny105119453p_enny
pens65649643p_en_s
pensil83013333p_ensil
pent66559073p_en_t
pentyls1236523p_entyls
penult8314653p_enult
peony105717563peony_
peril75425953p_eril
petal76526893p_etal
phenate12412203phenate
phenetol1344063phenetol
phenolic1546813phenolic
phenoms1437813phenoms
phenoxy2243483phenoxy
phenylene1744113phenylene
phew128417113phe__w
phial10313203ph_ial
phoenix1944363phoenix
phon95925383phon__
phone105621933phon_e
phoned124014553phoned
phones114121213phones
phoney143612983phoney
phoneys15437143phoneys
phonic133315213phonic
phonily1537103phonily
phono104917023phon_o
phonon114012033phonon
phonos114114793phonos
phons105221143phon_s
phrenic1438773phrenic
phrensy1533623phrensy
phyla13469183ph__yla
phyle134111153ph__yle
phytol14366563phytol
piety105817303piety_
pineal84817683pineal
piney105727503piney_
pinnal84814273pinnal
pinny105222063pinny_
piny911838353p_iny_
plena75816393plen_a
plench134010813plench
plenty11311413plenty
plenum1039503plenum
pleonal937243pleonal
plexal1536843plexal
poesy105014063poesy_
pony96434053p_ony_
porny106020193porny_
preanal9310713preanal
prexy174611583prexy_
prey96228483pre_y_
preys105717783pre_ys
propenyl1544583propenyl
propyl13358183propyl
protyl11308213protyl
pteryla1243303pteryla
punny104217713punny_
puny95526993p_uny_
renal55929503_renal
rhinal9510193rhinal
sheal84927703she_al
sheeny124912193sheeny_
shekel1338383shekel
shell84424123she_ll
shelly124414473shelly
shend94719973shen_d
shends105313773shends
shent85933503shen_t
sheol84318373she_ol
sheqel1846523sheqel
shiny115122143shiny_
sphene113412403sphen_e
sphenes123013163sphenes
sphenic1449093sphenic
spheral1238423spheral
sphery14318883sphery_
teeny85417883teeny_
thecal113310303thecal
thegnly1442613thegnly
then78429693then__
thenar92610003thenar
thence112010843thence
thens85921833then_s
thewy146311853thewy_
they107223753the_y_
thinly1238673thinly
thionyl1343713thionyl
uranyl936293uranyl
venal85523213_venal
vinyl115311623_vinyl
weeny115316163weeny_
wheal115716183whe_al
wheel115515333whe_el
when105723043when__
whenas124610463whenas
whence14187923whence
whens114618763when_s
whey135018713whe_y_
wheys145911553whe_ys
whiny144915573whiny_

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.390458182.1
2DLD Change Limit1127161805.39320900.4
3Display Results1801800.0603000.0
 (SQL Overall)1786911805.84330582.1
 
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.