A collection of TSQL scripts and data for data-scrubbing or for generating test data.
Random Word Generation for Data Scrubbing
https://www.sqlservercentral.com/articles/random-word-generation-for-data-scrubbing
At the bottom of each SQL script there is an example of how to call random data.
1. ```SELECT dbo.ds_fnRandomWord() ``` for a single random word. (Don't use this if using multiple times in a query)
2. ```SELECT dbo.ds_fnRandomWords(10)``` for a sentence of up to 1000 characters, the number in the brackets is the number of words to generate.
1. ```SELECT dbo.ds_fnRandomFirstName() ``` for a single random word. (Don't use this if using multiple times in a query)
2. ```SELECT dbo.ds_fnRandomFirstNames(10)``` for a sentence of up to 1000 characters, the number in the brackets is the number of names to generate.
1. ```SELECT dbo.ds_fnRandomLastName() ``` for a single random word. (Don't use this if using multiple times in a query)
2. ```SELECT dbo.ds_fnRandomLastNames(10)``` for a sentence of up to 1000 characters, the number in the brackets is the number of names to generate.
1. ```SELECT dbo.ds_fnRandomPhoneNumber() ``` for a single random word. (Don't use this if using multiple times in a query)
2. ```SELECT dbo.ds_fnRandomPhoneNumbers(10)``` for a sentence of up to 1000 characters, the number in the brackets is the number of phone numbers to generate.
https://britishsurnames.co.uk/surnames
https://github.com/powerlanguage/word-lists
https://www.thefreedictionary.com/5-letter-words.htm