Jump to main content

Go Wild! Try a Wildcard

1
2
3
4
5
45 reviews

Abstract

Everybody's favorite card in UNO® is the wildcard—why? Because it can stand for any card you want! Your computer uses the same idea. A wildcard on your computer can stand for anything you want when you search. Do this science project to find out if using wildcards to conduct a search can help you find more of what you're looking for.

Summary

Areas of Science
Difficulty
 
Time Required
Very Short (≤ 1 day)
Prerequisites
None
Material Availability
Readily available
Cost
Very Low (under $20)
Safety
No issues
Credits

UNO® is a registered trademark of Mattel, Inc.

Sara Agee, Ph.D., Science Buddies
Sandra Slutz, Ph.D., Science Buddies

Objective

Find out whether wildcards help you get more results from a computer search.

Introduction

When you search on a computer, you type in special words called search terms. Search terms are orders for the computer to find matches for what you want from a database. A computer database contains information, such as things that people can buy or books that students can check out. Search terms help find what you want in a database.

Sometimes search terms can have different spellings and ways they can be changed, such as adding a suffix. Instead of typing all of these possibilities, you can use wildcards as symbols to get the computer to look for all the spellings and changes to the search term. An (*), which is called an asterisk, is the most common wildcard symbol.

A search term can have a wildcard in any position that is normally a letter. The (*) acts as a substitute for any number of letters. It can appear in any position of a word, either at the beginning, middle, or end of a word. See Table 1 for examples. Databases often have different rules about using wildcards. Almost all databases allow wildcards in the middle of a search term (as in La*ra) or the end of a word (as in run*). However, not all databases allow wildcards at the beginning of a search term (as in *ball) or in between words (as in three * mice). You will have to experiment with the database you choose to see what is allowed and what is not.

Search Term Some Matches
humo*r humor, humour
La*ra Laura, Lara
run* run, runner, runners, running
doll* doll, dolls, dollhouse, dolly
rocket* rocket, rockets, rocketry, rocketman, rocketeer
*ball baseball, basketball, football
three * mice three blind mice, three clever mice, three kind mice
Table 1.This table shows that you can put a wildcard in many different places in a word. You can put it in front of letters, between letters, or at the end of a group of letters. Or you can even put it between other whole words.

You can use wildcards as a way to retrieve more information when searching for something in a database. An example of a database is an online library catalog. For example, if you wanted to search for a book about females in history you could run two keyword searches, one for "women history" and the other for "woman history." However, it would be easier and faster to do a single search using a wildcard: "wom*n history." Similarly, a wildcard is useful if the search term can be spelled in different ways like color (American spelling) and colour (British spelling). In this case, you could search using "colo*r" to find entries with both spellings. Wildcards should collect more results faster.

In this science project, you will search for a topic using an online library catalog. By using wildcards in different places, you can test whether using a wildcard will get better results from your search.

Terms and Concepts

To do this science project, you should know what the following terms mean. Have an adult help you look them up in a dictionary, search the Internet, or take you to your local library to find out more!

Questions

Bibliography

Consult this website for more information about using wildcards during searches:

This website offers help with creating graphs:

  • National Center for Education Statistics. (n.d.). Create a Graph. Retrieved May 4, 2011.

Materials and Equipment

Experimental Procedure

Doing Wildcard Searches

  1. Use a computerized library catalog to conduct your science project. The library catalog is a database of all the materials (such as books, magazines, movies, and CDs) in the library.
    1. Your local public library probably has a computerized library catalog (rather than an old-fashioned card catalog with paper cards in a drawer). Check with your local library to see whether you can access it online from any computer or just from the computers at the library.
    2. If you do not have easy access to a local computerized library catalog, you can search the Peninsula Library System web catalog instead.
  2. Test the wildcard rules of the library catalog you are using. Find out where you can use wildcards in a search term.
    1. Choose some search terms. Try putting a wildcard first at the beginning of the term, then in the middle, and then at the end. Write the wildcard words in your lab notebook in a data table like Table 2. You can either use the ones provided in Table 1 and Table 2, or come up with your own.
    2. Try each of the wildcard search terms and see if it returns any results. If it does, then the wildcard works in that position in your library catalog. If the search doesn't give you any results, then the wildcard does not work in that position in your library catalog. Record your findings in your data table.
Wildcard Position in Search Term Search Term Tried
(Examples from Table 1)
Results Returned?
(Yes/No)
     
     
beginning *ball  
middle La*ra  
end rocket*  
in between words Three * mice  
Table 2. Fill in a data table like this one to figure out which wildcard positions work with your library catalog.
  1. Once you know where you can use wildcards in your library catalog, you are ready to start experimenting. Decide on a topic to do your search. Choose something that is specific and that has multiple spellings, run/runner/running, women/woman, or color/colour.
  2. Choose your search terms. Choose terms with and without wildcards (for example, run, run*, runn*, runner, runner*, running, running*).
  3. Create a data table in your lab notebook, like Table 3, to record your data. Write your search terms in the table.
Search Term Used Wildcard Used?
(Yes/No)
Number of Matches in Library Catalog Did the Search Return What You Were Looking For?
       
       
       
Table 3. Record the results of your searches in a data table like this one.
  1. Type each term into the keyword search box of the computerized library catalog, and click "search" to get your results. Note: some library catalogs may have a subject search option rather than a keyword search option; either one is fine for this science project.
  2. For each search term, record in your data table:
    1. The total number of matches the search term returned.
    2. Notes on whether or not the search term returned all the types of matches you wanted. To figure this out, scan the list of titles that matched. If there are several hundred matches, look at multiple pages of matches. Were there any unexpected matches that you weren't thinking the search would find? If so, note that too.
  3. Continue for each search term you can think of. Do as many different combinations of terms and wildcards that you can think of.
  4. Repeat steps 3–8 using two more topics. When you repeat your experiment with additional topics, you make sure that your conclusions are based on enough data. In the end you should have a total of three topics, each with many different searches.

Graphing the Data

  1. Make a bar graph of your data for each of the three topics. On the horizontal X-axis create a bar for each search term, with and without wildcards, that you tried. The height (Y-axis) of a bar should represent the number of matches that search term returned.
    1. You can make the bar graph by hand or use a website like Create a Graph to make the graph on the computer and print it.
    2. In the end, you will have three bar graphs, one for each topic.
  2. Examine your bar graphs. What was the effect of the wildcard? Did it retrieve fewer matches or more matches than using the complete spelling of a specific word?
  3. Look back at your notes. Did you get any irrelevant results (ones that didn't make sense to you) for any of your search terms? What can you conclude about wildcards? Are they useful in database searches or not?
icon scientific method

Ask an Expert

Do you have specific questions about your science project? Our team of volunteer scientists can help. Our Experts won't do the work for you, but they will make suggestions, offer guidance, and help you troubleshoot.

Global Connections

The United Nations Sustainable Development Goals (UNSDGs) are a blueprint to achieve a better and more sustainable future for all.

This project explores topics key to Industry, Innovation and Infrastructure: Build resilient infrastructure, promote sustainable industrialization and foster innovation.

Variations

Careers

If you like this project, you might enjoy exploring these related careers:

Career Profile
Computers are essential tools in the modern world, handling everything from traffic control, car welding, movie animation, shipping, aircraft design, and social networking to book publishing, business management, music mixing, health care, agriculture, and online shopping. Computer programmers are the people who write the instructions that tell computers what to do. Read more
Career Profile
Databases are collections of similar records, like the products a company sells, information on all people with a driver's license for a state, or the medical records in a hospital. Database administrators have the important job of figuring out how to organize, access, store, search, cross-reference, and protect all those records. Their services are needed by law enforcement, government agencies, and every type of business imaginable. Management of large databases is also critical for… Read more

News Feed on This Topic

 
, ,

Cite This Page

General citation information is provided here. Be sure to check the formatting, including capitalization, for the method you are using and update your citation, as needed.

MLA Style

Science Buddies Staff. "Go Wild! Try a Wildcard." Science Buddies, 23 June 2020, https://www.sciencebuddies.org/science-fair-projects/project-ideas/CompSci_p016/computer-science/search-wildcards. Accessed 19 Mar. 2024.

APA Style

Science Buddies Staff. (2020, June 23). Go Wild! Try a Wildcard. Retrieved from https://www.sciencebuddies.org/science-fair-projects/project-ideas/CompSci_p016/computer-science/search-wildcards


Last edit date: 2020-06-23
Top
We use cookies and those of third party providers to deliver the best possible web experience and to compile statistics.
By continuing and using the site, including the landing page, you agree to our Privacy Policy and Terms of Use.
OK, got it
Free science fair projects.