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

207 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
pretext163966(None) 
pretest9517631pretest
pretexts1735601pretexts
pertest9317042pertest
precent113520262precent
precept133112512precept
prefect141011072prefect
preheat12413892preheat
prelect111013832prelect
premeet11615152premeet
premixt183510662premixt
present94022732present
preset84430982prese_t
pretax152310192pretax_
preteen939872preteen
pretell938242pretell
pretend104011012pretend
preterit10315852preterit
preterm11310162preterm
pretests10310012pretests
pretexted19135692pretexted
pretreat10311922pretreat
prevent124016552prevent
protect11313632protect
protest9317532protest
retest64028452_retest
urtext1337432ur_text
appetent1248083appetent
arete56031353arete__
aretes64425353arete_s
brevet115717333breve_t
context163913433context
credent10313973credent
detect94217403_detect
detent73624483_detent
detest74122843_detest
freest95318283fre_est
greatest939863greatest
greet65835323gre_e_t
greyest11348343greyest
hypertext2455133hypertext
iratest7312483iratest
patent84524923p_atent
peetweet1344973peetweet
percent113520603percent
percept133112523percept
perfect141010833perfect
perpent112318813perpent
perter84422283perte_r
pervert12315583pervert
peter74427593p_ete_r
peters86624593p_eters
petit74332653p_et_it
pietist9414033pietist
poetess938933poetess
portent93619643portent
potent84223353p_otent
praefect1544773praefect
praelect1247533praelect
prate75135983prate__
prated94924923prate_d
prater84825353prate_r
praters94921653praters
prates84633163prate_s
preact103220393pre_act
prebend12319443prebend
precast11314853precast
precede1239653precede
precents123015043precents
precepts14268893precepts
precess11310863precess
precut102016533pre_cut
predeath1447003predeath
predict12315323predict
pree67044733pre_e__
preed85128123pre_e_d
preedit10512463preedit
preelect1249643preelect
preempt1337723preempt
preen75925053pre_e_n
preens85020113pre_ens
preerect1259273preerect
prees75937173pre_e_s
preexist1747963pre_exist
prefects1598133prefects
prefer113813203prefe_r
prefers123713333prefers
prefix18356853prefix_
preheats1339413preheats
prelects1299723prelects
premeal11310523premeal
premed114617763preme_d
premeds12389593premeds
premen105017803preme_n
premix173710333premix_
premolt11312073premolt
prepotent1349573prepotent
preriot9316413preriot
prese75228383prese__
presell939303presell
presents103315643presents
presets94216423presets
presift12312223presift
presort95219543presort
prest75736353pr__est
prester93519623preste_r
presters103419003presters
pretape113511623pretape
pretaste10139523pretaste
preteens1038123preteens
pretells1047333pretells
pretence122312123pretence
pretends11299113pretends
pretense10199823pretense
preterite11613213preterite
preterits11410973preterits
pretermit1347133pretermit
preterms1237223preterms
pretested12149113pretested
pretexting20206973pretexting
pretold1049083pretold
pretor8315753pret_or
pretors9316813pretors
pretreats1146933pretreats
pretrim11310783pretrim
prettiest1199803prettiest
pretty11510873pret_ty
pretype14387483pretype
pretzel1835143pretzel
pretzels1934033pretzels
prevents133012293prevents
preverb14317063preverb
prex135722973pr__ex_
prexes154915953prexe_s
prexy174611583pr__exy
preyed125313203preye_d
preyer114413733preye_r
preyers124412363preyers
prezes173614693preze_s
priest84125423pr_iest
privet113821343prive_t
project1838453project
projet15315183proje_t
prosect11313393prosect
protea82214763prote_a
protean92412193protean
proteas92015123proteas
protects1239743protects
protege1059153protege
protei82615313prote_i
proteid103513673proteid
protein92414733protein
protend104012793protend
protests10310493protests
proteus92511593proteus
protist9320223protist
prowest12311533prowest
prudent10310433prudent
prutot8311823prut_ot
recent83630853_recent
recept103319083_recept
reest54938093_re_est
refect114319333_refect
refelt94521423_refelt
regent74127673_regent
reheat94423943_reheat
reject154116283_reject
relent64431853_relent
relet54749823_rele_t
remeet86325473_remeet
remelt85123123_remelt
remet74843723_reme_t
remex146315793_remex_
remixt155014853_remixt
renest64529713_renest
repeat85127213_repeat
repent84728873_repent
rerent63832453_rerent
reseat64131493_reseat
resect84424703_resect
resent63833623_resent
reset55051863_rese_t
retax124517973_retax_
rete44944133_rete__
reteam83214533_reteam
retear63115483_retear
retell63813643_retell
retem74221953_rete_m
retems83914573_retems
retene69224273_retene
retests73813853_retests
retint65633443_retint
retort66831153_retort
retreat7317533_retreat
revert93529113_revert
revest94623603_revest
revet84938843_reve_t
rewet85135153_rewe_t
subtext1647653subtext
teletext1545253teletext
text116033933___text
trevet94818913treve_t
tritest7315273tritest
ureter6313203urete_r
ureters7311823ureters
urtexts1433143ur_texts
vertex1637373vertex_

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 Filter1786911340270.403443402.0
2DLD Change Limit1340272076.86019537.5
3Display Results2072070.0802587.5
 (SQL Overall)1786912077.34324334.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.