Keep only Dictionary English words

[dhruvgulati]

I want to filter out Text Column which contains unique words

i dont have dictonary wordlist

I want to remove non english dictionary words from it and move them to another column
input 

gsgdhdfgc

hello

jnjkhhiu

hbjbhk788

name

output

hello

name

gsgdhdfgc

jnjkhhiu

hbjbhk788

[Vijay_A_Verma · Accepted solution]

You will need to have an English word list. The list of English words can be downloaded from Kaggle @ https://www.kaggle.com/datasets/yk1598/479k-english-words 

This list can be loaded in Power BI and then against this word query can be run.

I have created the solution in Excel (including above English words list) and uploaded to https://1drv.ms/x/s!Akd5y6ruJhvhuhUn9nNJwrRdjkP6?e=rZT3UG 

The solution will give this output

[dhruvgulati]

@Vijay_A_Verma guruji help needed