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 “pretermit” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

226 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
pretermit134713(None) 
preterit10315851preter_it
pretermits1445041pretermits
preterite11613212preter_ite
preterits11410972preter_its
preterm11310162preterm__
preterms1237222preterm_s
intermit101213593_intermit
permit10321683p___ermit
preadmit1346813pre_admit
preedit10512463pre_e_dit
preemie11310563pre_e_mie
preempt1337723pre_e_mpt
preerect1259273pre_erect
preferment1746323preferment
preformat1646363preformat
prelimit1259123pre_limit
presummit1553133presummit
preterites12411803preter_ites
preterminal1554583preterminal
pretermitted1752263pretermitted
pretest9517633prete__st
pretext1639663prete__xt
pretrain10310923pret_rain
pretreat10311923pret_reat
pretrim11310783pret_r_im
pretrims1238983pret_rims
proteomic1546743proteomic
reemit8717223_re_e_mit
ureteric1046243ureter_ic
craterlet1148414craterlet
criteria1048014criter_ia
demerit10314994_demer_it
determent121312904_determent
determine1249034_determine
eternity1146684__eternity
feterita1166484_feter_ita
fraternity1652354fraternity
greenlit945804gre_enlit
hermit11519444___hermit
intermat101114614_intermat
intermits111212204_intermits
intermix17156874_intermix
papeterie1345194papeter_ie
paternity1444834p_aternity
pederast1158594p_ederast
peerie83617894p_e_er_ie
peewit111110904p_e_e_wit
peperomia1553534p_eperomia
peppermint1554254peppermint
perfervid1842354perfervid
permits11314004p___ermits
perter84422284perter___
pertest9317044perte__st
perversity1853474perversity
pervert12315584perver__t
petechia1544174p_etechia
peter74427594p_eter___
petered103314974p_eter_ed
petering112516814p_etering
peters86624594p_eter__s
petit74332654p_et___it
portrait10510324port_rait
posterity1448694poster_ity
prater84825354prater___
praters94921654prater__s
preadmits1444924pre_admits
prearm104512354pre_arm__
prearmed1397994pre_armed
prearming14139224pre_arming
prearms11369174pre_arm_s
preatomic1546034preatomic
preaudit1177024pre_audit
precedent1448874precedent
precent113520264prece__nt
precept133112514prece__pt
prededuct1543104prededuct
predetermine1783174predetermine
predraft1447594pre_draft
preedits1168764pre_e_dits
preelect1249644pre_elect
preemies12512194pre_e_mies
preempts1444544pre_e_mpts
preenact12410184pre_enact
preerects1345414pre_erects
preexcite2044684pre_excite
preexempt2251904preexempt
preexist1747964pre_exist
prefect141011074prefe__ct
prefer113813204prefer___
preferments1844744preferments
preferred1555004preferred
preferrer1443894preferrer
preferring1645624preferring
prefers123713334prefer__s
preform1439614preform__
preformats1744414preformats
preformed17176204preformed
preforming1846234preforming
preforms1537404preform_s
preheat12413894prehe__at
prelect111013834prele__ct
prelimits1366014pre_limits
premarket17127854premarket
premedic1546304preme_dic
premeet11615154preme__et
premerger1444904premerger
premie103617994pr__e_mie
premix173710334pr__e_mix
premixt183510664pr__e_mixt
preprint12314184pre_print
preriot9316414pr__eriot
prescript1547034prescript
preselect1346984preselect
present94022734prese__nt
presentist12410094presentist
preserve13108804preser_ve
preserved15107564preserved
preserver14127014preserver
preserves14109074preserves
preservice1744494preservice
preserving1637364preserving
preset84430984prese___t
presort95219544presor__t
presplit1247754pre_split
prester93519624prester___
presterna1145264prester_na
presternum1452964presternum
presters103419004prester__s
presummits1652344presummits
preteen939874prete__en
preteens1038124prete_ens
pretell938244prete__ll
pretelling1338134pretelling
pretells1047334prete_lls
pretence122312124prete_nce
pretences132312614pretences
pretend104011014prete__nd
pretended1337194pretended
pretender1246664pretender
pretending1438614pretending
pretends11299114prete_nds
pretense10199824prete_nse
pretenses112210594pretenses
pretension1247534pretension
pretermitting1852554pretermitting
pretested12149114pretested
pretesting131810684pretesting
pretests10310014prete_sts
pretexted19135694pretexted
pretexting20206974pretexting
pretexts1735604prete_xts
pretor8315754pretor___
pretorial11512654pretorial
pretorian11511554pretorian
pretors9316814pretor__s
pretrains11410144pret_rains
pretreats1146934pretreats
pretrial10511984pret_rial
prettiest1199804prettiest
prevent124016554preve__nt
preverb14317064prever__b
preverbal1643884preverbal
preverbs15295304prever_bs
previsit13410074pre_visit
prewarm14479614prewarm__
prewarmed17104564prewarmed
prewarming18145174prewarming
prewarms15406734prewarm_s
preyer114413734preyer___
preyers124412364preyer__s
progeria1147944proger_ia
properdin1446274properdin
properest1349664properest
protamin121210544prot_amin
protect11313634prote__ct
protei82615314prote__i_
proteid103513674prote__id
protein92414734prote__in
proteinic1346884proteinic
proteome12228424proteom_e
proteomes13248654proteomes
protest9317534prote__st
protract12510604prot_ract
proxemic2146154proxe_mic
pterin81014154p__ter_in
pyodermic1952824pyodermic
pyrethrin1764404pyrethr_in
pyrethroid1963424pyrethroid
readmit1039824_re_admit
recommit1445554_recommit
recruit939774_re_cruit
reedit7617224_re_e_dit
reemits9611304_re_e_mits
reerect92915884_re_erect
referent112813424_referent
reformat1357654_reformat
reformist1445914_reformist
remit75737224_r__e_mit
reservist1246294_reservist
resubmit1243574_resubmit
retarget9312744_retarget
reteam83214534_reteam__
reteamed1138014_reteamed
reteaming122110444_reteaming
reteams9339564_reteam_s
retem74221954_rete_m__
retems83914574_rete_m_s
retest64028454_rete__st
retirant8313594_retirant
retort66831154_retor__t
retract91318114_ret_ract
retrain7615424_ret_rain
retreat7317534_ret_reat
retrim83514884_ret_r_im
retrims93612374_ret_rims
retrofit1148304_retrofit
reverent112615094_reverent
reverie103615164_rever_ie
revert93529114_rever__t
termite9313894___termite
territ63421384___territ
thermit12312014__thermit
ureter6313204ureter___
ureteral856234ureter_al
ureters7311824ureter__s

Search took 13 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 Filter1786911653290.436409841.7
2DLD Change Limit16532922612.42313308.3
3Display Results2262260.0932430.1
 (SQL Overall)17869122612.95213796.4
 
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.