4. A computer implemented system for progressively relaxing search terms provided by a user for finding matches of said search terms in a database, comprising: a processor; a storage module storing data of predefined types into a plurality of first data fields of a multicolumn table in said database, wherein said data is obtained by uniquely modifying data previously stored in a plurality of second data fields in the database, wherein said previously stored data is modified based on said predefined types of the previously stored data, wherein the predefined types comprise name, street address, city, state, zip, and country; an input module accepting a plurality of the search terms of the predefined types from said user, wherein length of said accepted search terms is computed; a comparison module comparing the accepted search terms with said stored data in said first data fields to find exact matches, if said length of the accepted search terms is greater than a predefined value; a modification module modifying the accepted search terms to structure first alternative queries if said exact matches are not found, wherein each of the accepted search terms is modified uniquely based on the predefined types of the accepted search terms; comparing by the comparison module said structured first alternative queries with the stored data in the first data fields to find exact matches; modifying by the modification module the first alternative queries to structure second alternative queries if said exact matches are not found, wherein each of the first alternative queries is modified uniquely based on the predefined types of the first alternative queries, and wherein said steps of modifying the accepted search terms and modifying the first alternative queries comprise concatenating and compensating for spelling errors, typographical errors, punctuation errors, phonological ambiguity, and non standard querying; comparing by the comparison module said structured second alternative queries with the stored data in the first data fields to find approximate matches; whereby said modification of the search terms and the first alternative queries to structure the first alternative queries and the second alternative queries respectively enables progressive relaxation of the search terms for finding matches of the search terms in the database.
4. A computer implemented system for progressively relaxing search terms provided by a user for finding matches of said search terms in a database, comprising: a processor; a storage module storing data of predefined types into a plurality of first data fields of a multicolumn table in said database, wherein said data is obtained by uniquely modifying data previously stored in a plurality of second data fields in the database, wherein said previously stored data is modified based on said predefined types of the previously stored data, wherein the predefined types comprise name, street address, city, state, zip, and country; an input module accepting a plurality of the search terms of the predefined types from said user, wherein length of said accepted search terms is computed; a comparison module comparing the accepted search terms with said stored data in said first data fields to find exact matches, if said length of the accepted search terms is greater than a predefined value; a modification module modifying the accepted search terms to structure first alternative queries if said exact matches are not found, wherein each of the accepted search terms is modified uniquely based on the predefined types of the accepted search terms; comparing by the comparison module said structured first alternative queries with the stored data in the first data fields to find exact matches; modifying by the modification module the first alternative queries to structure second alternative queries if said exact matches are not found, wherein each of the first alternative queries is modified uniquely based on the predefined types of the first alternative queries, and wherein said steps of modifying the accepted search terms and modifying the first alternative queries comprise concatenating and compensating for spelling errors, typographical errors, punctuation errors, phonological ambiguity, and non standard querying; comparing by the comparison module said structured second alternative queries with the stored data in the first data fields to find approximate matches; whereby said modification of the search terms and the first alternative queries to structure the first alternative queries and the second alternative queries respectively enables progressive relaxation of the search terms for finding matches of the search terms in the database. 6. The computer implemented system of claim 4 , further comprising a computation module for computing length of the accepted search terms, wherein said length is compared with a predefined value to determine need for comparing the accepted search terms with the stored data in the first data fields to find exact matches.