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

108 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
protended133680(None) 
portended1345641portended
pretended1337191pretended
propended1546161propended
pretender1246662pretender
proceeded1544092proceeded
promenaded1683632promenaded
protected14158652protected
proteide11239722proteide_
proteides12238782proteides
protend104012792proten__d
protends113010352protend_s
protested12159112protested
protruded1343442protruded
provender1544892provender
attended1035763_attended
bartended1344663bartended
contended1339273contended
distended12157923distended
drownded14334433dro_wnded
extended17135833_extended
forfended1743743forfended
friended1335033fr_iended
fronded12388863fro__nded
grounded1136573gro_unded
intended102310413_intended
mistended13137333mistended
patented1188893p_atented
pattened11299393patten_ed
pended103819013p___ended
perpended1546073perpended
poinded11358973p_o_inded
ponded105218773p_o__nded
portend103411193porten__d
portends11358963portend_s
portered112311533porte_red
potence11711363p_otence_
potences12710693p_otences
pounded114112793p_o_unded
preceded1438283prece_ded
precented14310693precented
preened103214983pr_een_ed
prefunded1644693prefunded
presented12311633presented
pretence122312123pretence_
pretences132312613pretences
pretend104011013preten__d
pretendedly1852423pretendedly
pretenders1345243pretenders
pretends11299113pretend_s
pretense10199823pretense_
pretenses112210593pretenses
pretested12149113pretested
pretexted19135683pretexted
prevented1539003prevented
proceed12310543proce__ed
proceeder1444163proceeder
processed1446803processed
prodded1257733pro__dded
profaned14207973profan_ed
professed1545243professed
progenies12314123progenies
projected21165823projected
prolonged13285413prolonged
promenade1485693promenade_
promenader1583493promenader
promenades1585413promenades
pronged113912393pro__nged
propelled1456903propelled
propend123311273propen__d
propends13249173propend_s
propene112716043propen_e_
propenes122816513propen_es
propense122410103propense_
propined133111503propin_ed
proponed132412033propon_ed
propounded1643503propounded
prosected14158633prosected
protease10209893protease_
proteases112110833proteases
protecter13179103protecter
protege1059153prote_ge_
protegee1156953prote_gee
protegees1275393protegees
proteges1149923prote_ges
proteid103513673prote__id
proteids11259943proteid_s
protending1446813protending
proteome12228423proteome_
proteomes13248653proteomes
proteose10229413proteose_
proteoses112211013proteoses
protester111510483protester
proteuses11238993proteuses
protonated1348593protonated
protrade1148213protrade_
protrude1144703protrude_
protrudes1245173protrudes
provenders1644273provenders
proverbed1743813proverbed
provided1536843pro_vided
remended123010393_remended
rended84524103_r__ended
rounded93013503_ro_unded
subtended1345153subtended
tended83819483___tended
trended94011763tr__ended
untended102611153_untended

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.1561145455.1
2DLD Change Limit1486411087.31320325.6
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.51523777.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.