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 “recertified” 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.

100 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
recertified175433(None) 
decertified1853921decertified
recertifies1644701recertifies
certified1548412__certified
decertifies1744572decertifies
desertified1654102desertified
rectified1539242rec__tified
refortified1853442refortified
retestified1554282retestified
reverified1745122rever_ified
uncertified17124622uncertified
acetified1545893_ace_tified
certifier1447353__certifier
certifies14310323__certifies
desertifies1544703desertifies
noncertified1873363noncertified
recertify1743643recertif__y
recertifying2183233recertifying
recodified1765533rec_odified
rectifier1457733rec__tifier
rectifies14310813rec__tifies
reedified1446503re_e_dified
refortifies1753773refortifies
reidentified1762933reidentified
rejustified2253033rejustified
renotified1455813re_notified
repurified1645163repur_ified
retestifies1444533retestifies
reverifies1645973rever_ifies
acetifier1444864_ace_tifier
acetifies1447134_ace_tifies
aerified121310134__aer_ified
beatified1577864__beatified
beautified1654224be_autified
carnified1547294__carnified
certifiers1545144__certifiers
citified1438254__c_itified
cornified1546624__cornified
decalcified2052664decalcified
decertify1843464decertif__y
decertifying2292794decertifying
demystified2152184demystified
denitrified1653784denitrified
devitrified1952714devitrified
diversified1962954diversified
electrified1754604_electrified
esterified1445404ester_ified
etherified1744084ether_ified
fortified1646504__fortified
fructified1942754fruc__tified
gentrified1545674gentr_ified
identified1545054_identified
metrified1547854me_tr_ified
micrified17126794mic_r_ified
mortified1547384__mortified
objectified2652874objectified
petrified1548334pe_tr_ified
prenotified1753984pre_notified
prettified1644944_prettified
rarified1239054r__ar_ified
ratified12310504r___atified
recarried1244984recar__ried
recautioned1483184recautioned
receipted1445334rece__ipted
received1437984rece__i_ved
recentrifuged2091384recentrifuged
receptive1648324recepti_ve_
receptivity2153874receptivity
reclassified1882674reclassified
recodifies16106324rec_odifies
recruited1236454rec_rui_ted
rectifiers1545174rec__tifiers
redefied1368224rede___fied
reedifies1347324re_e_difies
reglorified1652544reglorified
reidentifies1663224reidentifies
reified112913784r__e__ified
rejustifies2153124rejustifies
remodified17115264re_modified
renotifies1356894re_notifies
repacified1844894re_pacified
repertories1355834repertories
repurifies1546144repur_ifies
requalified2453614requalified
reserviced1643754reservi_ced
resinified1445764re_sinified
respecified1953374respecified
reunified1346594r__eunified
reverted122714714revert___ed
revertible1575194revertible_
revertive1548854reverti_ve_
revivified2043834re_vivified
scarified1547294_scar_ified
scorified1546194_scor_ified
terrified13147574__terrified
testified1397844__testified
unfortified1852914unfortified
verbified18146014__verbified
verified151510394__ver_ified
versified16147594__versified

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.423422437.4
2DLD Change Limit1488191009.25016088.5
3Display Results1001000.0462173.9
 (SQL Overall)1786911009.71918385.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.