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

125 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
pretended133719(None) 
pretender1246661pretender
protended1336801protended
perpended1546072perpended
portended1345642portended
preceded1438282prece_ded
precented14310692precented
preened103214982pre_en_ed
prefunded1644692prefunded
presented12311632presented
pretence122312122pretence_
pretences132312612pretences
pretend104011012preten__d
pretendedly1852422pretendedly
pretenders1345242pretenders
pretends11299112pretend_s
pretense10199822pretense_
pretenses112210592pretenses
pretested12149112pretested
pretexted19135682pretexted
prevented1539002prevented
propended1546162propended
remended123010392_remended
apprehended2052163apprehended
attended1035763_attended
bartended1344663bartended
coextended2142533coextended
contended1339273contended
defended1437223_defended
depended1337983_depended
distended12157923distended
emended11329603__emended
extended17135833_extended
forefended1843243forefended
friended1335033fr_iended
greatened1144583greaten_ed
greened93111263gre_en_ed
intended102310413_intended
mistended13137333mistended
patented1188893p_atented
pattened11299393patten_ed
peened94318153p_e_en_ed
pended103819013p___ended
petered103314963p_ete_red
prebend12319443preben__d
prebendal1444003prebendal
prebends13347883prebend_s
precede1239643prece_de_
precedes13310703prece_des
precessed1437523precessed
precluded1544213precluded
precoded1438863pre_coded
preener93114833pre_en_er
prefaded1537823pre_faded
preferred1555003preferred
preguided1443923preguided
prehandled1743633prehandled
preheated1539813preheated
prelected1439123prelected
preloaded1335923preloaded
preluded1236463pre_luded
premolded1544683premolded
preowned1435213preown_ed
prepense12238943prepense_
prerinsed1246323prerinsed
prescinded1644343prescinded
presence122213513presence_
presences132113793presences
presentee11411863presentee
presenter11311643presenter
preserved15107563preserved
presided12410553pre_sided
pretaped13339133pret_aped
pretasted12147963pretasted
preteen939873prete__en
pretending1438613pretending
pretreated1347623pretreated
prettied1159253pret_tied
pretyped16306123pret_yped
preventer1438593preventer
proceeded1544093proceeded
promenaded1683633promenaded
protected14158653protected
proteide11239723proteide_
proteides12238783proteides
protend104012793proten__d
protends113010353protend_s
protested12159113protested
protruded1343443protruded
provender1544893provender
reblended1355203_reblended
receded112713043_rece_ded
redenied10511283_redenied
reeded84022563_re_e_ded
refenced1438993_refenced
refunded1336953_refunded
relanded102410463_relanded
relented92614943_relented
remanded123011323_remanded
reminded123411523_reminded
rended84524103_r__ended
repented112614983_repented
reprehended1852943reprehended
rerented92516163_rerented
reseeded1038093_reseeded
resented92716963_resented
retarded102410753_retarded
reteamed1138013_reteamed
retene69224273_reten_e_
retenes76324623_reten_es
retested92212533_retested
retinted94414363_retinted
retinued95210823_retinued
retreaded1137053_retreaded
retuned86613973_retun_ed
revenged1337553_revenged
revenued1237223_revenued
rewedded1434513_rewedded
rewelded1335893_rewelded
rewinded13277673_rewinded
subtended1345153subtended
tended83819483___tended
trended94011763tr__ended
untended102611153_untended
weekended1842173weekended

Search took 9 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 Limit1486411257.86018911.1
3Display Results1251250.0631984.1
 (SQL Overall)1786911258.07922118.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.