Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “certifies” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

127 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
certifies1431032(None) 
certified1548421certified
certifier1447351certifier
certifiers1545151certifiers
acetifies1447132ace_tifies
aerifies111313392aer_ifies
beatifies1459282beatifies
carnifies1439892carnifies
citifies13310682c_itifies
cornifies1439002cornifies
decertifies1744572decertifies
fortifies1548692fortifies
metrifies1439802metrifies
mortifies1439392mortifies
petrifies14310362petrifies
recertifies1644702recertifies
rectifies14310812rectifies
terrifies12139722terrifies
testifies12139262testifies
verbifies17157132verbifies
verifies141313482ver_ifies
versifies15159332versifies
acerbities1444973acerbities
acetified1545893ace_tified
acetifier1444863ace_tifier
acetifiers1543403ace_tifiers
aerified121310143aer_ified
artifices1446473_artifices
beatified1577863beatified
beautifies1554473beautifies
brutifies1445713brutifies
calcifies1638923calcifies
carnified1547293carnified
cecities12312043ce_cities
centiares1167653centiares
centiles103615813centi_les
centimes124012613centi_mes
centuries11311333centuries
cercises12410933cerci_ses
cerises94722253cer_i_ses
cerites94823433cer_i_tes
certainties1353763certainties
certes84623083cert___es
certificates1992903certificates
certify1546243certif__y
certifying1945313certifying
certitudes1394493certitudes
cervices1537133cervi_ces
cervixes2054603cervi_xes
citified1438253c_itified
clarifies1448633clarifies
clerisies1147253cler_isies
coalifies1439113coalifies
codifies1439643c_odifies
cornified1546623cornified
cortices12615023corti_ces
crucifies1646123crucifies
curtesies1147523curtesies
curtsies1038733curt_sies
decertified1853933decertified
deifies113317453de__ifies
densifies1347993densifies
desertifies1544703desertifies
destinies10410843destinies
edifies113012283_e_difies
entities8617413_entities
ferities111416713fer_ities
fertilizes2247353fertilizes
fortified1646503fortified
fortifier1546253fortifier
fortifiers1644543fortifiers
gentrifies1446893gentrifies
gratifies1347993gratifies
horrifies15146393horrifies
identifies1445803identifies
jellifies1946263jellifies
justifies1945793justifies
metrified1547863metrified
mortified1547383mortified
mortifier1446923mortifier
mortifiers1544403mortifiers
mystifies1745883mystifies
nitrifies12107923nitrifies
notifies11310423_notifies
perfidies1546603perfidies
petrified1548343petrified
petrifier1447123petrifier
petrifiers1544673petrifiers
prettifies1545693prettifies
purifies13311923pur_ifies
rarifies11311933rar_ifies
ratifies11313513_ratifies
recertified1754343recertified
rectified1539253rectified
rectifier1457733rectifier
rectifiers1545173rectifiers
reedifies1347323reedifies
refortifies1753773refortifies
reifies104218283__reifies
renotifies1356893renotifies
reunifies1247583reunifies
scarifies1439603scar_ifies
scorifies1448023scor_ifies
serotinies1047443serotinies
stratifies1346743stratifies
terrified13147583terrified
terrifier12126603terrifier
terrifiers13144573terrifiers
tertiaries1047003tertiaries
testified1397843testified
testifier12116893testifier
testifiers13124503testifiers
torrifies12137033torrifies
uncertified17124633uncertified
verbified18146023verbified
verified151510403ver_ified
verifier14159203ver_ifier
verifiers15166063ver_ifiers
verities111418043ver_ities
versified16147603versified
versifier15156533versifier
versifiers16154143versifiers
vertices13612283verti_ces
verticils1446183verticils
vertigines1445223vertigines
vertigoes1354703vertigoes
vitrifies1547223vitrifies

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.423422437.4
2DLD Change Limit1486411278.40617682.7
3Display Results1271270.0632015.9
 (SQL Overall)1786911278.89220095.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.