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

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
refortified185344(None) 
refortifies1753771refortifies
fortified1646502__fortified
recertified1754332recertified
renotified1455812reno_tified
unfortified1852912unfortified
certified1548413ce__rtified
decertified1853923decertified
desertified1654103desertified
fortifier1546253__fortifier
fortifies1548693__fortifies
mortified1547383__mortified
prenotified1753983preno_tified
recertifies1644703recertifies
recodified1765533reco_dified
rectified1539243re__ctified
refortify1842833refortif__y
refortifying2252793refortifying
reglorified1652543reglor_ified
rejustified2253033rejustified
remodified17115263remo_dified
renotifies1356893reno_tifies
repurified1645163repur_ified
retestified1554283retestified
reverified1745123rever_ified
aerified121310134ae__r_ified
beatified1577864be__atified
beautified1654224be_autified
certifier1447354ce__rtifier
certifies14310324ce__rtifies
cornified1546624__cornified
decertifies1744574decertifies
deformities1744284deformities
demystified2152184demystified
denitrified1653784denitrified
desertifies1544704desertifies
detoxified2243084deto_xified
devitrified1952714devitrified
fortifiers1644534__fortifiers
gentrified1545674gentr_ified
glorified1445004_glor_ified
horrified16145064__horrified
metrified1547854me_tr_ified
mortifier1446924__mortifier
mortifies1439394__mortifies
notified1238364__no_tified
petrified1548334pe_tr_ified
premodified20113584premo_dified
prenotifies1644884preno_tifies
preportioned1754254preportioned
prettified1644944pre__ttified
rarified1239054r__ar_ified
ratified12310504r___atified
recodifies16106324reco_difies
rectifier1457734re__ctifier
rectifies14310814re__ctifies
reedified1446504re__edified
reforested1445384refor_ested
reforged13268704refor___ged
reformatted1752624reformatted
reformed14249604refor___med
refrained1347224ref_rai_ned
refried113513874ref_r___ied
refurbished20112374refurbished
refurnished18102744refurnished
reglorifies1553004reglor_ifies
reidentified1762934reidentified
reified112913784re____ified
rejustifies2153124rejustifies
remodifies16116024remo_difies
repacified1844894re_pacified
reported11312704report___ed
repurifies1546144repur_ifies
requalified2453614requalified
resinified1445764re_sinified
resolidified1751724resolidified
resorted9313494resort___ed
respecified1953374respecified
retestifies1444534retestifies
retorted9312334retort___ed
reunified1346594re__unified
reverifies1645974rever_ifies
revivified2043834re_vivified
scorified1546194_scor_ified
terrified13147574te__rrified
testified1397844te__stified
torrified13125594__torrified
uncertified17124624uncertified
verbified18146014ve__rbified
verified151510394ve__r_ified
versified16147594ve__rsified

Search took 10 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 Filter1786911488190.420425454.8
2DLD Change Limit148819918.81316886.3
3Display Results91910.0461978.3
 (SQL Overall)178691919.27919257.6
 
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.