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

136 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
presence12221351(None) 
presences132113791presences
pretence122312121pretence
credence1387822credence
prepense12238942prepense
prescience16157292prescience
present94022732presen_t
presented12311632presented
presentee11411862presentee
presenter11311642presenter
presents103315642presents
preserve13108802preserve
preslice1258622preslice
pretences132312612pretences
pretense10199822pretense
prudence1346332prudence
refence12312242_refence
absence1137713_absence
appetence1544993appetence
brisance1245953brisance
credences1498143credences
defence1339893_defence
essence947673_essence
frequence2344803frequence
greenie8310123gre_enie
mergence13137943mergence
patience1247523patience
penance11313443p_enance
pence94924453p___ence
permeance1545913permeance
personae102410553personae
pleasance1344303pleasance
potence11711363p_otence
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
preprice1488873preprice
prepuce1337833pre_puce
prepunch1743643prepunch
prerace11414123pre_race
prerenal1049083prerenal
prerinse1038633prerinse
presage10312293pres_age
presale9416353pres_ale
presciences17127273presciences
prescore124812373prescore
prese75228383pres___e
preselect1346983preselect
presell939303prese_ll
presells1058283presells
presentees1247923presentees
presentence1546393presentence
presenters1239863presenters
presently1449063presently
preserved15107563preserved
preserver14127013preserver
preserves14109073preserves
preservice1744493preservice
preset84430983prese__t
presets94216423prese_ts
presettle1145943presettle
preshape1537533preshape
preside10715613pres_ide
presidency1844653presidency
presliced1435983presliced
preslices1338213preslices
presolve1347073presolve
presong1039843preson_g
pressure1039773pressure
prestige11310733prestige
prestore104217353prestore
presume11310303pres_ume
pretend104011013preten_d
pretended1337193pretended
pretender1246663pretender
pretends11299113pretends
pretenses112210593pretenses
prevalence1745483prevalence
prevent124016553preven_t
prevented1539003prevented
preventer1438593preventer
prevents133012303prevents
prince104114763pr__ince
prisere9310943prise_re
propene112716043propen_e
propense122410103propense
prosect11313393prose_ct
province1546923province
prudences1446683prudences
prurience1344763prurience
pubescence1854763pubescence
purulence1345033purulence
putrescence17114273putrescence
recency1438633_recency
refenced1439003_refenced
refences13311853_refences
regency1337363_regency
resect84424703_rese_ct
resee54336333_rese__e
reseize1639553_reseize
resend75016773_resen_d
resends83513713_resends
resent63833623_resen_t
resented92716963_resented
resents74221223_resents
reserve101011203_reserve
residence1268913_residence
respace11310913_respace
retene69224273_reten_e
revenge1138573_revenge
revenue1039533_revenue
vergence14128273vergence
virescence17134863virescence

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.640279204.7
2DLD Change Limit1461621367.22020244.0
3Display Results1361360.0462956.5
 (SQL Overall)1786911367.90622601.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.