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

81 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
potentiates1311486(None) 
potentates12106331potent_ates
potentiate12115891potentiate_
potentiated1494361potentiated
potentate1197252potent_ate_
potentials1245542potentia_ls
potentiator1353492potentiator
potentiators1453222potentiators
licentiates1354203licentiates
potencies1369303potenci__es
potential1148533potentia__l
potentialities1674203potentialities
potentially1656793potentially
potentiating1554283potentiating
potentiation1455973potentiation
potentiations1555183potentiations
potentillas1362253potentillas
accentuates1553064accentuates
argentites1147024argenti_tes
attenuates1074104atten_uates
authenticates1892494authenticates
catenates11311814caten__ates
cementites1476184cementi_tes
centiares1167654__centiares
commentates17107614comment_ates
concentrates16118214concentrates
detentists1145504detentist_s
domesticates1753544domesticates
edentates1046954_edent_ates
eventuates1394184_eventuates
extenuates1744474exten_uates
instantiates1253614instantiates
intenerates1148084intenerates
intestates10159434intest_ates
licentiate1254804licentiate_
nonentities1158264nonentities
noninitiates12123664noninitiates
novitiates1343734no_vitiates
oftentimes1542634oftenti_mes
orientates1046044orient_ates
parentages1345484parent_ages
patencies1349174patenci__es
patentees1196544patent__ees
patinates113814694patin__ates
patriates11311364pat__riates
patriciates1545324patriciates
pectates122213954p__ect_ates
penates93321594p__en__ates
penetrates1248724p__enetrates
penlites10312274p__enli_tes
pentanes10316084p__ent_anes
perennates1256764peren_nates
petites93820204p__e_ti_tes
phenates13611574p_hen__ates
phenolates1547014p_henolates
plenties10314694p_lenti__es
poetises10313954po_e_ti_ses
poetizes19310254po_e_ti_zes
polentas1038744polent_a__s
pollenates1246744pollen__ates
postdates1248864po__stdates
potences12710694poten___ces
potentiality1754334potentiality
potentilla1253004potenti_lla
potentiometer1761584potentiometer
potentiometers1861554potentiometers
pottages112910454pot__t_ages
potties93723544pot__ti__es
poverties1439514poverti__es
prentices131111904p_renti_ces
propitiates1546204propitiates
protectorates1752864protectorates
protonates12411694proton__ates
steatites939844_steati_tes
tectites1039994__tecti_tes
tektites1236614__tekti_tes
teniases838624__ten_iases
tentages91011044__tent_ages
testates83615454__test_ates
totemites1146604tote_mi_tes
ventilates1347604__ventilates

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.1701051123.5
2DLD Change Limit148819818.94016646.4
3Display Results81810.0461760.9
 (SQL Overall)178691819.15619516.3
 
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.