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

65 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
penetrate114923(None) 
penetrated1347301penetrated
penetrates1248721penetrates
denitrate10810532denitrate
fenestrate1345292fenestrate
generate9312902gene_rate
penetrable1446042penetrable
penetrance1444902penetrance
penetrant1148462penetrant
penetrants1245272penetrants
penetrative1646112penetrative
perpetrate1476642perpetrate
venerate11312902vene_rate
celebrate1348083celebrate
cerebrate1348653cerebrate
deaerate9314173deae_rate
denervate1346173denervate
denigrate1168693denigrate
denitrated1298033denitrated
denitrates1169513denitrates
dentate8315153den_t_ate
desecrate1249083desecrate
deuterate1049513deuterate
emeerate10410103_emeerate
enervate1148453_enervate
execrate1739653_execrate
exenterate1795683exenterate
federate12310883fede_rate
fenestrae1243783fenestra_e
fenestrated1554243fenestrated
generated11310203gene_rated
generates10312713gene_rates
genette838863genet__te
hebetate1347053hebet_ate
impetrate1345723impetrate
menstruate1244413menstruate
nitrate72017013__nitrate
pandurate1245883pandurate
pectate112214693pe_ct_ate
peerage1089803pe_e_rage
peltate92013773pe_lt_ate
peneplane1344663peneplane
penetralia1254123penetralia
penetrances1544803penetrances
penetrating1447663penetrating
penetration1349893penetration
pennate93314033pen__nate
pentane9415743pen_t_ane
perborate13510143perborate
perennate1147783perennate
perforate1459463perforate
perorate10417923pe_rorate
perpetrated1675073perpetrated
perpetrates1566203perpetrates
perpetuate1454783perpetuate
petrale9312623p__etrale
prostrate11412483prostrate
punctate1246473punct_ate
punctuate1343743punctuate
reiterate9412933reiterate
tenebrae1044873tenebra_e
vegetate1246673veget_ate
venenate1147933vene_nate
venerated1339953vene_rated
venerates12312263vene_rates

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.1731032896.0
2DLD Change Limit148641657.67319372.0
3Display Results65650.0302166.7
 (SQL Overall)178691657.87622688.0
 
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.