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 “petrified” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
petrified154833(None) 
metrified1547851metrified
petrifier1447121petrifier
petrifies14310361petrifies
aerified121310132ae_rified
certified1548412certified
gentrified1545672gentrified
metrifies1439802metrifies
nitrified1346722nitrified
petrifiers1544672petrifiers
prettified1644942prettified
purified1438742p_urified
putrefied1543672putrefied
terrified13147572terrified
verified151510392ve_rified
vitrified1645982vitrified
acetified1545893acet_ified
aerifies111313393ae_rifies
beatified1577863beatified
certifier1447353certifier
certifies14310323certifies
citified1438253cit_ified
clarified1546973clarified
deified123112413de__ified
denitrified1653783denitrified
densified1446713densified
detoxified2243083detoxified
devitrified1952713devitrified
edified12339713_e_dified
electrified1754603electrified
esterified1445403esterified
etherified1744083_etherified
fortified1646503fortified
gentrifier1444813gentrifier
gentrifies1446893gentrifies
glorified1445003glorified
horrified16145063horrified
introfied1345603introfied
jellified2044813jellified
lithified1644463lithified
metricized2445423metricized
micrified17126793micrified
mortified1547383mortified
nigrified1445323nigrified
nitrifier1245963nitrifier
nitrifies12107923nitrifies
notified1238363not_ified
pacified1638363p_acified
patriated1238533patriated
patricide1446613patricide
periled10316323pe_ri_led
perilled11410113pe_rilled
perished14310083pe_rished
petioled1137993pet_ioled
petrify1536573petrif__y
petrifying1945823petrifying
pretrimmed1742633pretrimmed
prettifier1543973prettifier
prettifies1545693prettifies
purifier1338573p_urifier
purifies13311923p_urifies
putrefier1443123putrefier
putrefies1444663putrefies
rarified1239053_rarified
ratified12310503rat_ified
rectified1539243rectified
reedified1446503reedified
reified112913783re__ified
repurified1645163repurified
retried84419153retr__ied
retrieved1385093retrieved
retrimmed1443673retrimmed
retrofired1443423retrofired
reunified1346593reunified
reverified1745123reverified
scarified1547293scarified
scorified1546193scorified
serifed11811463se_rif_ed
seriffed1594973se_riffed
specified1746253spe_cified
terrifier12126603terrifier
terrifies12139723terrifies
testified1397843testified
torrified13125593torrified
trifid1039063__trifi_d
trifled113711963__trifled
verbified18146013verbified
verifier14159203ve_rifier
verifies141313483ve_rifies
versified16147593versified
vitrifies1547223vitrifies

Search took 8 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.406440125.6
2DLD Change Limit148641917.51619776.6
3Display Results91910.0461978.3
 (SQL Overall)178691917.96822426.1
 
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.