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

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

129 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
protested1215911(None) 
pretested12149111pretested
protected14158651protected
protester111510481protester
pretasted12147962pretasted
pretexted19135692pretexted
priested1138392pr_iested
processed1446802processed
professed1545242professed
projected21165822projected
prosected14158632prosected
protecter13179102protecter
protended1336802protended
protest9317532protest__
protesters12169382protesters
protestor11178492protestor
protests10310492protest_s
retested92212532_retested
arrested939153ar_rested
attested936293_attested
contested12310693contested
crested103416533cr__ested
detested10279623_detested
forested12312463_forested
frosted113211873fro__sted
frowsted1534313fro_wsted
molested11178243_molested
obtested1135453_obtested
ovotestes1242533ovotestes
patented1188893p_atented
pirouetted1342943pirouetted
plotted104612373plot__ted
portended1345643portended
portered112311543porte_red
posted93722493p_o__sted
potted94624013p_ot__ted
precented14310693precented
precessed1437523precessed
preheated1539813preheated
prelected1439133prelected
prepasted14137673prepasted
presented12311633presented
pressed103317313pr__essed
prester93519623pr__ester
pretaste10139523pretaste_
pretastes11119423pretastes
pretended1337193pretended
pretest9517633pretest__
pretests10310013pretest_s
pretreated1347623pretreated
prevented1539003prevented
probated13410863pro_bated
proceed12310553proce__ed
proceeded1544103proceeded
processer1346893processer
processes13310233processes
procreated1546443procreated
proette9312363pro_ette_
proettes10312763pro_ettes
professes1437873professes
profited14279973pro_fited
progestin1248423progestin
progressed1445353progressed
promised133010873promis_ed
promoted13310543pro_moted
prompted1536903pro_mpted
pronated11414053pro_nated
propelled1456913propelled
propended1546163propended
propertied15137253propertied
prophesied1894793prophesied
proposed132011073propos_ed
prorated11513713pro_rated
prosecuted1544283prosecuted
prosed94921093pro__s_ed
proselyted1643433proselyted
prospected1744873prospected
prostrated1349423prostrated
protases102115033protas_es
protease10209893protease_
proteases112110833proteases
protect11313633protect__
protecters14168253protecters
protector13169533protector
protects1239743protect_s
protege1059153prote_ge_
protegee1156963prote_gee
protegees1275393protegees
proteges1149923prote_ges
proteid103513673prote__id
proteide11239723proteide_
proteides12238783proteides
protend104012793prote__nd
proteome12228423proteome_
proteomes13248653proteomes
proteose10229413proteose_
proteoses112211013proteoses
protestant1247423protestant
protesting131910253protesting
protestors12169313protestors
proteuses11238993proteuses
protheses1449073prothes_es
protist9320223protist__
protistan1145983protistan
protistic13410983protistic
protists10313363protist_s
protonated1348593protonated
protostar1146693protostar
protostele1245073protostele
protracted1545763protracted
protruded1343443protruded
proverbed1743813proverbed
prowesses1437193prowesses
prowest12311533prowest__
reested82916233_r_eested
renested92212953_renested
rested74430783_r__ested
retasted92412113_retasted
revested122612243_revested
roasted83912663_ro_asted
roosted83211883_ro_osted
rotated82715293_rot_ated
rotted74524433_rot__ted
rousted84013323_ro_usted
tested74421523___tested
trotted83711283trot__ted
unprotected1652753unprotected
untested92612413_untested
wrested113410933wr__ested

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.423422437.4
2DLD Change Limit1486411296.53022762.8
3Display Results1291290.0462804.3
 (SQL Overall)1786911296.99925530.9
 
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.