/** SCRIPT INSERT NEW WORD */
require ('mysqli_conn.php');
$conn = new mysqli($servername, $username, $password, $dbname);

$word = $conn->real_escape_string('mot');
$sorted_letters = sort_alpha_noaccent_tolower($word);

$insert = "INSERT INTO dictionnaire SET 
  scrabble_lettre = '{$word[0]}',
  scrabble_nbr = '".strlen($word)."',
  scrabble_name = '$word',
  scrabble_vb = '',
  sorted_letters = '$sorted_letters'";

$conn->query($insert);

/** SCRIPT LOOKING FOR ANAGRAMMES */
require ('mysqli_conn.php');
$conn = new mysqli($servername, $username, $password, $dbname);

$search = 'chanter';// le mot recherché
$sorted_letters = $conn->real_escape_string(sort_alpha_noaccent_tolower($search));// l'anagramme unique de recherche

$query = "SELECT * FROM dictionnaire WHERE sorted_letters = '$sorted_letters'";// sélectionne tous les mots du dictionnaire ayant cet anagramme unique
$words = $conn->query($query);

/* affiche tous les mots excepté le mot original */
while ($word = $words->fetch_object())
{
  if ($word->scrabble_name != $search)
    echo $word->scrabble_name.'<br/>';
}