looking for such words
sheiling
shieling
data on row 1
results required on c1 to leave one row on results from one result to another
find file attached
looking for such words
sheiling
shieling
data on row 1
results required on c1 to leave one row on results from one result to another
find file attached
You need a better explanation of what is required i,e, why are the highlighted values selected: and we do not need a file with 34K records
There are pairs which have the exactly the same letters [RADIOES/ROADIES] but AERADIO vs ? or GOATIES vs ?
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
RADIOES/ROADIES this is not similar ,these are two words you can make out of RDSAIOE
Your reply appears to indicate that you want the letters that can used to form more than one word so is the result in C1 is RDSAIOE for you example .
Please post a SMALL file showing exactly what you want in C1 and WHY.
There is "fuzzy logic" to compare similar words. I know that it has been implemented in Power Query to some extent, but I don't know much about it myself.
Artik
Ethanal
ethanol
sheiling
shieling
word change by one vowel is what i am looking for and vowel inter change like sheiling and shieling both valid words appearing on a1 the master list
She iling
shi eling
these two are not same look at them closer
You highlighted
ROASTIE
Where the previous 2 words are OARIEST and OTARIES so I assume some "connection" between the 3
These are not simple vowel interchanges as you suggest in post #6.
I am also looking for such words too , interchange by one vowel change
inwises
unwises
xxxYou highlighted
ROASTIE
Where the previous 2 words are OARIEST and OTARIES so I assume some "connection" between the 3
These are not simple vowel interchanges as you suggest in post #6.
I had highlighted roastie since it is a new word from our old world dictionary
Last edited by AliGW; 01-01-2022 at 06:12 AM. Reason: QUOTE tags added.
Given your last reply, the required outcome is much more complex than you previously indicated [multiple criteria] as you are implying there is a need to identify "new" words based on some (undefined) dictionary.
Maybe :
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
How do you insert module if ALT+F11 does not work
I am curious of what the karedog does
Karedog wow , pulling pairs , I have one version where have similars as row 1 and 2 ,3 and 4 , this one nicer
A portion of what it pulled , it kicked a 44,444 dictionary all at less than 7 seconds , some set are more than 3 pairs , picked everything it found
IDOLATER
IDOLATOR
ADULATOR
DONARIES
DENARIES
DENARIUS
SEDATION
SEDITION
SUDATION
Last edited by makinmomb; 03-21-2022 at 12:09 PM. Reason: at to a
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks