Jump to content

Wikipedia:WikiProject Red Link Recovery/Link matching script/US vs UK spelling differences

Add links
From Wikipedia, the free encyclopedia

This requires mysql 5.0.3 or newer.

For now, the list contains only a small set of differences. For more possible words to change, see American and British English spelling differences

NB: This doesn't need to include differences in the doubling of letters (ie 'jewellery' vs 'jewelry') as these are picked up by other reports. 

DROP TABLE wordmap;

CREATE TABLE wordmap (
   a varchar(255) binary NOT NULL,
   b varchar(255) binary NOT NULL
);

INSERT INTO wordmap VALUES ('aeroplane','airplane');
INSERT INTO wordmap VALUES ('aeroplanes','airplanes');
INSERT INTO wordmap VALUES ('aging','ageing');
INSERT INTO wordmap VALUES ('aluminium','aluminum');
INSERT INTO wordmap VALUES ('analog','analogue');
INSERT INTO wordmap VALUES ('analogs','analogues');
INSERT INTO wordmap VALUES ('analyzed','analyses');
INSERT INTO wordmap VALUES ('analyzes','analyses');
INSERT INTO wordmap VALUES ('analyzer','analyser');
INSERT INTO wordmap VALUES ('analyzing','analysing');
INSERT INTO wordmap VALUES ('annexe','annex');
INSERT INTO wordmap VALUES ('apologize','apologise' );
INSERT INTO wordmap VALUES ('apologized','apologised' );
INSERT INTO wordmap VALUES ('apologizes','apologises' );
INSERT INTO wordmap VALUES ('apologizer','apologiser' );
INSERT INTO wordmap VALUES ('apologizing','apologising' );
INSERT INTO wordmap VALUES ('archeology','archaeology' );
INSERT INTO wordmap VALUES ('archeological','archaeological' );
INSERT INTO wordmap VALUES ('archeologist','archaeologist' );
INSERT INTO wordmap VALUES ('argument','arguement');
INSERT INTO wordmap VALUES ('arguments','arguements');
INSERT INTO wordmap VALUES ('argumentative','arguementative');
INSERT INTO wordmap VALUES ('armor','armour');
INSERT INTO wordmap VALUES ('armors','armours');
INSERT INTO wordmap VALUES ('armored','armoured');
INSERT INTO wordmap VALUES ('armorer','armourer');
INSERT INTO wordmap VALUES ('armoring','armouring');
INSERT INTO wordmap VALUES ('baptize','baptise' );
INSERT INTO wordmap VALUES ('baptizes','baptises' );
INSERT INTO wordmap VALUES ('baptized','baptised' );
INSERT INTO wordmap VALUES ('baptizm','baptism' );
INSERT INTO wordmap VALUES ('baptizmal','baptismal' );
INSERT INTO wordmap VALUES ('baptizms','baptisms' );
INSERT INTO wordmap VALUES ('behavior','behaviour');
INSERT INTO wordmap VALUES ('behaviors','behaviours');
INSERT INTO wordmap VALUES ('behavioral','behavioural');
INSERT INTO wordmap VALUES ('carburettor','carburetor');
INSERT INTO wordmap VALUES ('carburettors','carburetors');
INSERT INTO wordmap VALUES ('catalog','catalogue');
INSERT INTO wordmap VALUES ('catalogs','catalogues');
INSERT INTO wordmap VALUES ('cataloged','catalogued');
INSERT INTO wordmap VALUES ('center','centre' );
INSERT INTO wordmap VALUES ('centers','centres' );
INSERT INTO wordmap VALUES ('centered','centred' );
INSERT INTO wordmap VALUES ('check','cheque');
INSERT INTO wordmap VALUES ('checks','cheques');
INSERT INTO wordmap VALUES ('checker','chequer');
INSERT INTO wordmap VALUES ('checkers','chequers');
INSERT INTO wordmap VALUES ('color','colour');
INSERT INTO wordmap VALUES ('colors','colours');
INSERT INTO wordmap VALUES ('colored','coloured');
INSERT INTO wordmap VALUES ('coloring','colouring');
INSERT INTO wordmap VALUES ('cosy','cozy');
INSERT INTO wordmap VALUES ('criticize','criticise');
INSERT INTO wordmap VALUES ('criticizes','criticises');
INSERT INTO wordmap VALUES ('criticized','criticised');
INSERT INTO wordmap VALUES ('criticizing','criticising');
INSERT INTO wordmap VALUES ('criticizism','criticisism');
INSERT INTO wordmap VALUES ('criticizisms','criticisisms');
INSERT INTO wordmap VALUES ('defense','defence');
INSERT INTO wordmap VALUES ('defenses','defences');
INSERT INTO wordmap VALUES ('dialog','dialogue');
INSERT INTO wordmap VALUES ('dialogs','dialogues');
INSERT INTO wordmap VALUES ('draft','draught');
INSERT INTO wordmap VALUES ('drafts','draughter');
INSERT INTO wordmap VALUES ('drafter','draughter');
INSERT INTO wordmap VALUES ('drafted','draughted');
INSERT INTO wordmap VALUES ('drafting','draughting');
INSERT INTO wordmap VALUES ('encylopedia','encylycopaedia');
INSERT INTO wordmap VALUES ('encylopedae','encylycopaedae');
INSERT INTO wordmap VALUES ('encylopedias','encylycopaedias');
INSERT INTO wordmap VALUES ('encylopedic','encylycopaedic');
INSERT INTO wordmap VALUES ('flavor','flavour');
INSERT INTO wordmap VALUES ('flavors','flavours');
INSERT INTO wordmap VALUES ('flavored','flavoured');
INSERT INTO wordmap VALUES ('flavoring','flavouring');
INSERT INTO wordmap VALUES ('flavorings','flavourings');
INSERT INTO wordmap VALUES ('gram','gramme' );
INSERT INTO wordmap VALUES ('grams','grammes' );
INSERT INTO wordmap VALUES ('kilogram','kilogramme' );
INSERT INTO wordmap VALUES ('kilograms','kilogrammes' );
INSERT INTO wordmap VALUES ('grey','gray');
INSERT INTO wordmap VALUES ('greys','grays');
INSERT INTO wordmap VALUES ('greyed','grayed');
INSERT INTO wordmap VALUES ('greyer','grayer');
INSERT INTO wordmap VALUES ('greying','graying');
INSERT INTO wordmap VALUES ('greyer','grayer');
INSERT INTO wordmap VALUES ('harbor','harbour');
INSERT INTO wordmap VALUES ('harbors','harbours');
INSERT INTO wordmap VALUES ('harbored','harboured');
INSERT INTO wordmap VALUES ('harborer','harbourer');
INSERT INTO wordmap VALUES ('harboring','harbouring');
INSERT INTO wordmap VALUES ('honor','honour');
INSERT INTO wordmap VALUES ('honors','honours');
INSERT INTO wordmap VALUES ('honored','honoured');
INSERT INTO wordmap VALUES ('honoring','honouring');
INSERT INTO wordmap VALUES ('humor','humour' );
INSERT INTO wordmap VALUES ('humors','humours' );
INSERT INTO wordmap VALUES ('humored','humoured' );
INSERT INTO wordmap VALUES ('humorist','humourist' );
INSERT INTO wordmap VALUES ('humorists','humourists' );
INSERT INTO wordmap VALUES ('humoring','humouring' );
INSERT INTO wordmap VALUES ('judgment','judgement');
INSERT INTO wordmap VALUES ('judgments','judgements');
INSERT INTO wordmap VALUES ('kilometre','kilometer');
INSERT INTO wordmap VALUES ('kilometres','kilometers');
INSERT INTO wordmap VALUES ('labor','labour' );
INSERT INTO wordmap VALUES ('labors','labours' );
INSERT INTO wordmap VALUES ('labored','laboured' );
INSERT INTO wordmap VALUES ('laborer','labourer' );
INSERT INTO wordmap VALUES ('laboring','labouring' );
INSERT INTO wordmap VALUES ('license','licence');
INSERT INTO wordmap VALUES ('licenses','licences');
INSERT INTO wordmap VALUES ('licensed','licenced');
INSERT INTO wordmap VALUES ('licenser','licencer');
INSERT INTO wordmap VALUES ('licensee','licencee');
INSERT INTO wordmap VALUES ('licensing','licencing');
INSERT INTO wordmap VALUES ('maneuver','manoeuvre');
INSERT INTO wordmap VALUES ('maneuvers','manoeuvres');
INSERT INTO wordmap VALUES ('maneuvered','manoeuvred');
INSERT INTO wordmap VALUES ('maneuverer','manoeuvree');
INSERT INTO wordmap VALUES ('maneuvering','manoeuvring');
INSERT INTO wordmap VALUES ('medieval','mediaeval');
INSERT INTO wordmap VALUES ('memorize','memorise');
INSERT INTO wordmap VALUES ('memorizes','memorises');
INSERT INTO wordmap VALUES ('memorized','memorised');
INSERT INTO wordmap VALUES ('memorizer','memoriser');
INSERT INTO wordmap VALUES ('memorizing','memorising');
INSERT INTO wordmap VALUES ('meter','metre' );
INSERT INTO wordmap VALUES ('meters','metres' );
INSERT INTO wordmap VALUES ('metered','metred' );
INSERT INTO wordmap VALUES ('meterer','metrer' );
INSERT INTO wordmap VALUES ('metering','metring' );
INSERT INTO wordmap VALUES ('mould','mold');
INSERT INTO wordmap VALUES ('moulds','molds');
INSERT INTO wordmap VALUES ('moulding','molding');
INSERT INTO wordmap VALUES ('moulded','molded');
INSERT INTO wordmap VALUES ('moustache','mustache');
INSERT INTO wordmap VALUES ('moustaches','mustaches');
INSERT INTO wordmap VALUES ('neighbor','neighbour');
INSERT INTO wordmap VALUES ('neighbors','neighbours');
INSERT INTO wordmap VALUES ('neighbored','neighboured');
INSERT INTO wordmap VALUES ('neighborhood','neighbourhood');
INSERT INTO wordmap VALUES ('neighborhoods','neighbourhoods');
INSERT INTO wordmap VALUES ('organize','organise' );
INSERT INTO wordmap VALUES ('organizes','organises' );
INSERT INTO wordmap VALUES ('organized','organised' );
INSERT INTO wordmap VALUES ('organizer','organiser' );
INSERT INTO wordmap VALUES ('organizing','organising' );
INSERT INTO wordmap VALUES ('organizm','organism' );
INSERT INTO wordmap VALUES ('organizms','organisms' );
INSERT INTO wordmap VALUES ('pajamas','pyjamas');
INSERT INTO wordmap VALUES ('plough','plow');
INSERT INTO wordmap VALUES ('ploughs','plows');
INSERT INTO wordmap VALUES ('ploughed','plowed');
INSERT INTO wordmap VALUES ('ploughing','plowing');
INSERT INTO wordmap VALUES ('program','programme');
INSERT INTO wordmap VALUES ('programs','programmes');
INSERT INTO wordmap VALUES ('programed','programmed');
INSERT INTO wordmap VALUES ('programer','programmer');
INSERT INTO wordmap VALUES ('programing','programming');
INSERT INTO wordmap VALUES ('programers','programmers');
INSERT INTO wordmap VALUES ('realise','realize');
INSERT INTO wordmap VALUES ('realises','realizes');
INSERT INTO wordmap VALUES ('realised','realized');
INSERT INTO wordmap VALUES ('realising','realizing');
INSERT INTO wordmap VALUES ('realism','realizm');
INSERT INTO wordmap VALUES ('recognize','recognise' );
INSERT INTO wordmap VALUES ('recognizes','recognises' );
INSERT INTO wordmap VALUES ('recognized','recognised' );
INSERT INTO wordmap VALUES ('recognizer','recogniser' );
INSERT INTO wordmap VALUES ('recognizing','recognising' );
INSERT INTO wordmap VALUES ('recognizm','recognism' );
INSERT INTO wordmap VALUES ('rumor','rumour');
INSERT INTO wordmap VALUES ('rumors','rumours');
INSERT INTO wordmap VALUES ('rumored','rumoured');
INSERT INTO wordmap VALUES ('savior','saviour');
INSERT INTO wordmap VALUES ('saviors','saviours');
INSERT INTO wordmap VALUES ('savor','savour');
INSERT INTO wordmap VALUES ('savors','savours');
INSERT INTO wordmap VALUES ('savored','savoured');
INSERT INTO wordmap VALUES ('savoring','savouring');
INSERT INTO wordmap VALUES ('savory','savoury');
INSERT INTO wordmap VALUES ('speciality','specialty');
INSERT INTO wordmap VALUES ('specialities','specialties');
INSERT INTO wordmap VALUES ('specialize','specialise' );
INSERT INTO wordmap VALUES ('specializes','specialises' );
INSERT INTO wordmap VALUES ('specialized','specialised' );
INSERT INTO wordmap VALUES ('specializing','specialising' );
INSERT INTO wordmap VALUES ('specializm','specialism' );
INSERT INTO wordmap VALUES ('specializms','specialisms' );
INSERT INTO wordmap VALUES ('storey','story');
INSERT INTO wordmap VALUES ('storeyed','storyed');
INSERT INTO wordmap VALUES ('theatre','theater');
INSERT INTO wordmap VALUES ('theatres','theaters');
INSERT INTO wordmap VALUES ('tyre','tire');
INSERT INTO wordmap VALUES ('tyres','tires');

LOCK TABLES wordmap WRITE, crushed_art WRITE, crushed_links WRITE;

UPDATE crushed_art, wordmap
SET title = replace( title, a, b )
WHERE title REGEXP concat( '[[:<:]]', a, '[[:>:]]' );

UPDATE crushed_links, wordmap
SET link = replace( link, a, b )
WHERE link REGEXP concat( '[[:<:]]', a, '[[:>:]]' );

UNLOCK TABLES;
Retrieved from "https://wiki.riteme.site/w/index.php?title=Wikipedia:WikiProject_Red_Link_Recovery/Link_matching_script/US_vs_UK_spelling_differences&oldid=293128176"