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

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

122 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
recertifies164470(None) 
decertifies1744571decertifies
recertified1754341recertified
certifies14310322__certifies
decertified1853932decertified
desertifies1544702desertifies
rectifies14310812rec__tifies
refortifies1753772refortifies
retestifies1444532retestifies
reverifies1645972rever_ifies
acetifies1447133_ace_tifies
certified1548423__certified
certifier1447353__certifier
certifiers1545153__certifiers
desertified1654103desertified
recertify1743643recertif__y
recertifying2183233recertifying
recodifies16106323rec_odifies
rectified1539253rec__tified
rectifier1457733rec__tifier
rectifiers1545173rec__tifiers
reedifies1347323re_e_difies
refortified1853443refortified
reidentifies1663223reidentifies
rejustifies2153123rejustifies
renotifies1356893re_notifies
repertories1355833repertories
repurifies1546143repur_ifies
retestified1554283retestified
reverified1745123rever_ified
uncertified17124633uncertified
acerbities1444974_acerbities
acetified1545894_ace_tified
acetifier1444864_ace_tifier
acetifiers1543404_ace_tifiers
aerifies111313394__aer_ifies
beatifies1459284__beatifies
beautifies1554474be_autifies
carnifies1439904__carnifies
celerities1289774celer_ities
citifies13310684__c_itifies
cornifies1439004__cornifies
decalcifies1953054decalcifies
decertify1843464decertif__y
decertifying2292794decertifying
demystifies2052374demystifies
denitrifies1544264denitrifies
devitrifies1852874devitrifies
diversifies1853814diversifies
electrifies1645754_electrifies
esterifies1347154ester_ifies
eternities1048064_eternities
etherifies1645284ether_ifies
fortifies1548694__fortifies
fructifies1843224fruc__tifies
gentrifies1446904gentr_ifies
identifies1445804_identifies
legerities1196884leger_ities
metrifies1439804me_tr_ifies
micrifies16118674mic_r_ifies
mortifies1439394__mortifies
necessities1354574necessities
nemertines1245964nemerti_nes
noncertified1873364noncertified
objectifies2553344objectifies
petrifies14310364pe_tr_ifies
preceptories1854964preceptories
prenotifies1644884pre_notifies
prettifies1545694_prettifies
rarifies11311944r__ar_ifies
ratifies11313514r___atifies
recarries1147874recar__ries
receives1339744rece__i_ves
recencies13312254rece__ncies
recentrifuges1971354recentrifuges
receptacles1752404receptacles
receptions1449744recepti_ons
receptive1648334recepti_ve_
receptivities2053904receptivities
receptivity2153884receptivity
recessives1545674recessi_ves
reclassifies1782854reclassifies
recodified1765544rec_odified
recreancies1544654recreancies
rectories11314664rec__tories
rectrices1338874rectr_i_ces
redefies12710164rede___fies
reedified1446504re_e_dified
reentries9311774re_ent_ries
refectories1646434refectories
reglorifies1553004reglorifies
reidentified1762934reidentified
reifies104218284r__e__ifies
rejustified2253034rejustified
remodifies16116024re_modifies
renotified1455814re_notified
repacifies1745654re_pacifies
repertoires1352654repertoires
repurified1645164repur_ified
requalifies2344354requalifies
reserpines1245844reserpi_nes
reservices1544894reservi_ces
resinifies1346914re_sinifies
respecifies1853724respecifies
reunifies1247584r__eunifies
reveries112518514rever___ies
reversibles1682854reversibles
revertible1575194revertible_
revertive1548854reverti_ve_
revivifies1944554re_vivifies
scarifies1439604_scar_ifies
scorifies1448024_scor_ifies
secretaries1345424secretaries
secretories1345944secretories
securities1248554secur_ities
severities1348524sever_ities
temerities1268494temer_ities
terrifies12139724__terrifies
testifies12139264__testifies
verbifies17157134__verbifies
verifies141313484__ver_ifies
versifies15159334__versifies

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 Limit1488191229.07616397.0
3Display Results1221220.0631936.5
 (SQL Overall)1786911229.56218687.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.