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

117 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
pretending143861(None) 
protending1446811protending
perpending1646682perpending
portending1446192portending
prebinding1696162prebinding
preceding15129362prece_ding
precenting151012152precenting
preening113115842pre_en_ing
prefunding1745232prefunding
presenting131013022presenting
pretelling1338132pretelling
pretesting131810682pretesting
pretexting20206972pretexting
preventing161210262preventing
propending1646142propending
relending112412022_relending
remending132311312_remending
resending112313362_resending
unpretending1672832unpretending
apprehending2152493apprehending
attending11136373_attending
bartending1444913bartending
breeding123411843bre_e_ding
coextending2252913coextending
contending1449123contending
defending15298353_defending
depending14208783_depending
distending1348333distending
emending12298893__emending
extending1835853_extending
forefending1943493forefending
friending1495553fr_iending
greatening1245443greaten_ing
greening103112533gre_en_ing
greenling1136753gre_enling
greenwing1434693gre_enwing
intending1139983_intending
mistending1447953mistending
patenting1248943p_atenting
peening103318303p_e_en_ing
pending114119773p___ending
petering112516813p_ete_ring
prebidding1783843prebidding
precessing1598743precessing
precluding1644173precluding
precoding15109733pre_coding
preeing103817673pre_e__ing
prefading16149033pre_fading
preferring1645623preferring
preguiding1544493preguiding
prehandling1853423prehandling
preheating16310723preheating
prelecting15310163prelecting
preloading1446583preloading
preluding1337053pre_luding
premolding1644673premolding
preopening1546243preopen_ing
prerinsing1347643prerinsing
prescinding1744853prescinding
preselling1338693preselling
preserving1637363preserving
presetting131010833presetting
presiding13510903pre_siding
pretaping1439133pret_aping
pretasting13239283pretasting
pretend104011013pretend___
pretended1337193pretend_ed
pretender1246663pretend_er
pretenders1345243pretenders
pretends11299113pretend__s
pretension1247533pretension
pretensions1347083pretensions
pretreating1448893pretreating
prettying1536043pret_tying
pretyping1764943pret_yping
preweaning1645633preweaning
proceeding1644673proceeding
promenading1774373promenading
protecting151910213protecting
protesting131910253protesting
protruding1453633protruding
rebinding13249483_rebinding
reblending1455813_reblending
receding122713763_rece_ding
redenying1437783_redenying
reeding94124133_re_e_ding
refeeding14247933_refeeding
refencing15188853_refencing
refinding14259943_refinding
refunding14258073_refunding
relanding112110923_relanding
relenting102716773_relenting
remanding132211143_remanding
reminding132311543_reminding
rending93924263_r__ending
repenting122316553_repenting
reprehending1973473reprehending
rereading111212713_rereading
rerenting102617663_rerenting
reseeding112410493_reseeding
resenting102619293_resenting
retarding111110653_retarding
reteaming122110443_reteaming
retearing102214253_retearing
retelling102112493_retelling
retesting102614603_retesting
retinting102215253_retinting
retreading12128483_retreading
retuning9311583_retun_ing
revenging1438083_revenging
rewedding1535093_rewedding
rewelding1436913_rewelding
rewinding14238933_rewinding
subtending1445103subtending
tending94419163___tending
trending103012833tr__ending
weekending1942233weekending

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 Filter1786911406030.420425454.8
2DLD Change Limit1406031176.56321423.6
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.02925422.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.