A neighbour has been charged with murder after a mother was stabbed to death in front of three children.