Prompt that makes text input consistent before storing and comparing, so values that look the same are the same. Paste it into an AI tool of your choice, which then makes text input consistent.
Results depend on the tool, the model and what you enter.
Fill in
What you type stays in this browser window. We store and send nothing.
Which field?
username
email address
person or company name
search term
voucher or product code
What happens?
duplicate accounts with the same name
search misses entries
login sometimes fails
confusable usernames
nothing yet, prevention
Which languages appear?
only German and English
several European languages
non-Latin scripts too
Turkish or Azerbaijani
don't know
Your prompt
Help me make text input consistent so that values that look the same also compare as equal.
Field: [Field]
Problem: [Problem]
Languages: [Languages]
Steps: 1. Read the code that stores, searches or checks the field for uniqueness, and list every comparison point. 2. Check whether accented letters can arrive once as a single character and once as a letter plus combining mark, and whether a fixed normalisation form is applied before comparing. 3. Check case handling: is a language-independent case fold used for comparison instead of simple lowercasing? 4. Flag invisible characters, non-breaking spaces and leading or trailing whitespace that create duplicates. 5. For usernames and domains, check whether confusable characters from other scripts allow impersonation, and propose a rule for it. 6. Decide whether the original value is kept for display while only a normalised copy is compared, and describe a one-time cleanup of existing data.
Output: list of comparison points, rule for normalisation form, case folding and whitespace, code proposal, test cases and a plan for existing data.
Take particular care to compare only normalised values and keep the original for display.
Before you answer, check: Are all instructions met? If key information is missing or a placeholder in square brackets is still in the text, ask instead of guessing. Mark assumptions as assumptions.
You have edited the prompt. Changes in the fields above no longer overwrite it.
This is an instruction for an AI, not the result itself.
Fill in the fields or tap a suggestion. Leave out names, addresses and other personal data.
Copy the finished prompt into an AI tool of your choice.
Paste the code for storing, searching and checking uniqueness of the field, plus three to five example values that cause trouble, without real personal data.
Why does this work?
"Müller" can be stored in two ways that look identical but are not. Then search cannot find the customer, and the same account can be created twice.
Tips
Run the cleanup of existing data on a copy first, because it surfaces real duplicates that someone has to merge.
Prompt that plans a data backfill in small, resumable batches with clear brakes.
Prompt · Intermediate · about 15 min
You may use our prompts freely, including at work. Please do not republish them as your own collection. We give no warranty for AI results; check them yourself. Terms of use
