Update-TestEditDistance.ps1

$scriptPath = Join-Path (Get-Location) "TestEditDistance.sql";
$response = Invoke-WebRequest "https://raw.githubusercontent.com/GlobalNamesArchitecture/damerau-levenshtein/master/spec/files/damerau_levenshtein_test.txt" -UseBasicParsing;
$lines = $response.Content.Split() | Where-Object { $_ -like "*|*|*|*" };

@"
DECLARE @test_cases TABLE
(
    Word1 NVARCHAR(128),
    Word2 NVARCHAR(128),
    ExpectedEditDistance INT
)
VALUES
"@ | Out-File $scriptPath -Encoding UTF8;

@(
    $lines.ForEach({
        $columns = $_.Split("|");
        $rowValue = "`t(N'$($columns[0])', N'$($columns[0])', $($columns[3]))";

        if ($_.Equals($lines[-1])) {
            Write-Output "$rowValue;";
        } else {
            Write-Output "$rowValue,"
        }
    });
) | Out-File $scriptPath -Append -Encoding UTF8;