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

164 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
pretense1019982(None) 
prepense12238941prepense
pretence122312121pretence
pretenses112210591pretenses
preens85020112pre_ens_
prerinse1038632prerinse
presence122213512presence
preteens1038122preteens_
pretences132312612pretences
pretend104011012preten_d
pretended1337192pretended
pretender1246662pretender
pretends11299112pretends
pretest9517632prete_st
propense122410102propense
protease10209892protease
proteose10229412proteose
retene69224272_reten_e
retenes76324622_retenes
appetence1544993appetence
aretes64425353arete_s_
credence1387823credence
creese84014333cre_e_se
cretins93216423cretins_
cretonne1044363cretonne
defense1137503_defense
detente83313603_detente
greatens9307593greatens_
greenie8310123gre_enie
greens75716873gre_ens_
hypertense1855803hypertense
intense72511903_intense
ketene106613003_keten_e
ketenes114813503_ketenes
patens84820863p_atens_
pattens95414923pattens_
pectens11189203pectens_
peens76428193p_e_ens_
pentene9313793penten_e
pentenes10315633pentenes
permease1246503permease
pertest9317043perte_st
pertness10310093pertness
perverse1336103perverse
peters86624593p_eters_
petuntse1042473p_etuntse
platens94213983platens_
poetess938933poete_ss
poetesses1137233poetesses
poetise9314043poet_ise
poteens92910883poteens_
potence11711363p_otence
praters94921653praters_
prates84633163prate_s_
prebend12319443preben_d
prebends13347883prebends
precede1239643prece_de
precedes13310703precedes
precensor1345253precensor
precent113520263precen_t
precented14310693precented
precents123015043precents
precess11310863prece_ss
precessed1437523precessed
precesses13310463precesses
prechose15129773prechose
precieuse1344613precieuse
precise113518173pre_cise
precrease1345233precrease
preemie11310563pre_emie
preen75925053pre_en__
preened103214983pre_ened
preener93114833pre_ener
prees75937173pre_e_s_
prefers123713333prefers_
prehensile1544663prehensile
premeds12389583premeds_
premen105017803premen__
premise113818553pre_mise
premorse1237553premorse
premune1138933premun_e
prepensely1753303prepensely
prerenal1049083prerenal
prerinsed1246323prerinsed
prerinses1138813prerinses
prese75228383pr__e_se
presences132113793presences
present94022733presen_t
presented12311633presented
presentee11411863presentee
presenter11311643presenter
presents103315643presents
preserve13108803preserve
presets94216423presets_
presters103419003presters_
pretape113511623pret_ape
pretapes122811533pretapes
pretaste10139523pretaste
preteen939873prete_en
pretell938233prete_ll
pretells1047323pretells
pretenders1345243pretenders
pretension1247533pretension
preterit10315843preterit
preterite11613203preterite
preterm11310153prete_rm
preterms1237223preterms
pretested12149113pretested
pretests10310013pretests
pretext1639663prete_xt
pretexted19135683pretexted
pretexts1735603pretexts
pretors9316803pretors_
pretties10615133pretties
pretype14387483pret_ype
pretypes15337263pretypes
pretzels1934033pretzels_
prevent124016553preven_t
prevented1539003prevented
preventer1438593preventer
prevents133012293prevents
previse123713793pre_vise
prexes154915943prexe_s_
preyers124412363preyers_
prezes173614693preze_s_
propene112716043propen_e
propenes122816513propenes
proteans102811543proteans_
proteas92015123proteas_
proteases112110833proteases
protege1059153prote_ge
protegee1156953protegee
proteges1149923proteges
proteide11239723proteide
proteinase1244533proteinase
proteins102114283proteins_
protend104012793proten_d
protended1336803protended
protends113010353protends
protensive1546203protensive
proteome12228423proteome
proteoses112211013proteoses
protest9317533prote_st
proteus92511593proteus_
proteuses11238993proteuses
protons93118003protons_
prudence1346333prudence
refence12312233_refence
release7312763_release
retems83914573_retems_
retest64028453_rete_st
retinae75517333_retinae
retine66237333_retin_e
retines75134673_retines
retinue75414843_retinue
retune69121953_retun_e
retunes76918403_retunes
retuse66617223_ret_use
revenge1138573_revenge
revenue1039533_revenue
reverse103913743_reverse
tense55225843___tense
treens65317873tre_ens_
ureters7311823ureters_

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621648.32617554.9
3Display Results1641640.0802050.0
 (SQL Overall)1786911648.56220870.2
 
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.