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

139 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
pretence12231212(None) 
presence122213511presence
pretences132312611pretences
pretense10199821pretense
appetence1544992appetence
credence1387822credence
potence11711362p_otence
prepense12238942prepense
presences132113792presences
pretend104011012preten_d
pretended1337192pretended
pretender1246662pretender
pretends11299112pretends
pretenses112210592pretenses
prudence1346332prudence
refence12312232_refence
retene69224272_reten_e
appetences1644593appetences
appetency1853553appetency
credences1498143credences
cretonne1044363cretonne
defence1339893_defence
detente83313603_detente
frequence2344803frequence
greenie8310123gre_enie
ketene106613003_keten_e
mergence13137943mergence
patency1466313p_atency
patience1247523patience
penance11313443p_enance
pence94924453p___ence
penitence1348093penitence
pentene9313793penten_e
permeance1545913permeance
pertinence1445833pertinence
pittance1246113pittance
portance12310123portance
potences12710693p_otences
potency1457433p_otency
prance104318573pr__ance
prebend12319443preben_d
prebends13347883prebends
precancel1546203precancel
precancer1547093precancer
precede1239653prece_de
precedence1746113precedence
precent113520263precen_t
precented14310693precented
precents123015043precents
precinct1459423precinct
preemie11310563pre_emie
preen75925053pre_en__
preenact12410183pre_enact
preened103214993pre_ened
preener93114833pre_ener
preens85020113pre_en_s
preface14510923pre_face
prefect141011073prefe_ct
preference1776983preference
prelect111013833prele_ct
prelunch1543433prelunch
premen105017803premen__
premune1138933premun_e
prentice121012353prentice
preplace1488983preplace
prepotency1953783prepotency
preprice1488873preprice
prepuce1337833pre_puce
prepunch1743643prepunch
prerace11414123pre_race
prerenal1049083prerenal
prerinse1038633prerinse
prescience16157293prescience
present94022733presen_t
presented12311633presented
presentee11411863presentee
presentence1546393presentence
presenter11311643presenter
presents103315643presents
preserve13108803preserve
preslice1258623preslice
pretape113511623pret_ape
pretaste10139523pretaste
preteen939873prete_en
preteens1038123preteens
pretell938243prete_ll
pretells1047333pretells
pretenders1345243pretenders
preterit10315843preterit
preterite11613203preterite
preterm11310163prete_rm
preterms1237223preterms
pretest9517633prete_st
pretested12149113pretested
pretests10310013pretests
pretext1639663prete_xt
pretexted19135693pretexted
pretexts1735603pretexts
pretype14387483pret_ype
prevalence1745483prevalence
prevent124016553preven_t
prevented1539003prevented
preventer1438593preventer
prevents133012293prevents
prince104114763pr__ince
propene112716043propen_e
propense122410103propense
protease10209893protease
protect11313633prote_ct
protege1059153prote_ge
protegee1156963protegee
proteide11239723proteide
protend104012793proten_d
protended1336803protended
protends113010353protends
proteome12228423proteome
proteose10229413proteose
province1546923province
prudences1446683prudences
prurience1344763prurience
purulence1345033purulence
recency1438633_recency
refenced1438993_refenced
refences13311843_refences
regency1337363_regency
renitence1149053_renitence
reteach1237413_reteach
retenes76324623_retenes
reticence1347623_reticence
retinae75517333_retinae
retine66237333_retin_e
retinue75414843_retinue
retrace91417343_retrace
retrench1346283_retrench
retune69121953_retun_e
revenge1138573_revenge
revenue1039533_revenue
sentence1099863sentence
vergence14128273vergence

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621397.39019778.3
3Display Results1391390.0463021.7
 (SQL Overall)1786911397.85922737.1
 
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.