I once read a story in the Talmud about a woman of ill-repute named Megaddalela, whom a rabbi told a man to marry. I used it for a research project and can no longer find the original source. And I do not speak Hebrew to find it in the original texts. Anyone familiar with the story? And what the original source is? I thought it was Chagigah 5a, but looking again I do not see the story there. Grateful for anyone familiar with the source!
You are referencing Pesachim 87a which is discussing Gomer bat Divlayim, the wife of Hoshea in Hoshea 1:3.
The Holy One, Blessed be He, said: What shall I do to this Elder who does not know how to defend Israel? I will say to him: Go and take a prostitute and bear for yourself children of prostitution. And after that I will say to him: Send her away from before you. If he is able to send her away, I will also send away the Jewish people. This deliberation provides the background of the opening prophecy in Hosea, as it is stated: “The Lord said to Hosea: Go, take for yourself a wife of prostitution and children of prostitution” (Hosea 1:2). And then it is written: “So he went and took Gomer the daughter of Diblaim” (Hosea 1:3), and the Sages interpreted her name homiletically. “Gomer”; Rav said she was so called because everyone would finish [gomerim] having relations with her and satisfy their desires with her.