MySQL/PHP fulltext search 1 word similarity
===

I have a client that wants to manage his SEO titles/descriptions for any page in the website, so I thought about making a module where he can enter the URL/TITLE/DESCRIPTION and the website will check if there is an entry for that page, and if there is, show it.

I have tried this:

	$url = 'http://'.$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'];
	
	$q_seo = $conexio->query('SELECT modulseo.titol, modulseo.descripcio, MATCH(modulseo.url) AGAINST("'.$url.'") AS score FROM modulseo WHERE MATCH(modulseo.url) AGAINST("'.$url.'") ORDER BY score DESC LIMIT 0,1');
		
	if(mysql_num_rows($q_seo)>0)
	{
		$d_seo = mysql_fetch_array($q_seo);
	
		$titol = $d_seo['titol'];
		$descripcio = $d_seo['descripcio'];
	
	}
	else
	{
		$titol = 'default title';
		$descripcio = 'default description';
	}


This obviously doesn't work, as I believe fulltext search only works with matching different words, not the similarity between 1 word and another, as the client can enter in the backend urls like:

+ `http://www.domain.com/index.php`
+ or `http://domain.com/index.php`
+ or `http://www.domain.com/index.php?language=fr`
+ or `http://domain.com/index.php?language=fr`
+ etc..

and then the user of the website can access any of those urls, so there must be a way to match any of the urls with the any of the ones the client entenred in the backend.

Any clue about how to do this?