+ Reply to Thread
Results 1 to 6 of 6

similar by vowels x 3

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    similar by vowels x 3

    NONETTI
    NONETTE
    NONETTO

    Looking for words that nature

    Manually done results , macro to run a 5o,ooo row dictionary to pull that

    Added examples

    ANIMATE
    ANIMATI
    ANIMAT0

    HALLOED
    HELLIED
    HILLIED
    HOLLOED
    HILLIED
    Attached Files Attached Files
    Last edited by makinmomb; 03-10-2022 at 04:39 PM. Reason: exmaple adds

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,209

    Re: similar by vowels x 3

    Do you mean words with ONLY 3 vowels AND all starting with the same letter?

    As requested before, PLEASE give a better explanation than "Looking for words that nature"
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: similar by vowels x 3

    HALLOED
    HELLIED
    HILLIED
    HOLLOED
    HILLIED

    Can be more than 3 above explained closer in brackers

    H[A]LLOED
    H[E]LLIED
    H[I]LLIED
    H[O]LLOED
    H[I]LLIED

    Only one vowel position changed in the above 5

  4. #4
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: similar by vowels x 3

    ANIMATE
    ANIMATI
    ANIMAT0

    Some will fall to 3 sets like above

    ANIMAT[E]
    ANIMAT[I]
    ANIMAT[0]
    Last edited by makinmomb; 03-11-2022 at 03:07 AM. Reason: FALL

  5. #5
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,416

    Re: similar by vowels x 3

    Your request is not entirely clear to me. Please answer these questions...

    1) If there are only 0, 1 or 2 vowels, you are not interested in them, correct?

    2) What if there are 4 or more vowels, can only 3 of them be different but a 4th, 5th, etc. must match?

    3) Or is what you are looking for all the consonant to match by letter and position ignoring any and all vowels?

  6. #6
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: similar by vowels x 3

    1 Yes 2 sets not interested
    2 Any number of vowels min 3 , if it has 4 display 4 if it has 5 display 5
    3 6 letters match same position , vowel change , should work with EIGHT letter words where 7 positions must match with a vowel changing at 1 position

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] similar by vowels
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-21-2022, 12:08 PM
  2. [SOLVED] Similar by vowels , 7 and 8 letters
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 08-30-2017, 03:11 AM
  3. [SOLVED] Vowels counter
    By makinmomb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-25-2017, 02:29 AM
  4. Similars with vowels end
    By makinmomb in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 05-01-2017, 08:09 AM
  5. Counting Vowels
    By jengalinato in forum Excel General
    Replies: 6
    Last Post: 08-24-2014, 03:03 AM
  6. Count Vowels
    By charmedcharmer in forum Excel General
    Replies: 1
    Last Post: 03-12-2007, 08:11 PM
  7. How to do those lines on top of vowels?
    By stars in forum Excel General
    Replies: 1
    Last Post: 06-15-2006, 03:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1