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

142 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
nepetas93594(None) 
nepeta837891nepeta_
pesetas938752pesetas
repeats94316052repeats
beets76131443be_et_s
begets96215523beget_s
berets85822523beret_s
berettas1046733berettas
besets85718803beset_s
betas75528763__betas
bettas84913923be_ttas
celestas1057083celestas
centas85020703ce_ntas
cepes94424463cepe__s
cestas85018543ce_stas
deets65330243de_et_s
defeats113511233defeats
deletes83117933deletes
deltas74414823de_ltas
depends11348993depends
deperms1236603deperms
depletes112810643depletes
depots94716343depot_s
depths12428573dep_ths
deputes104911783deputes
edemas9310503_edemas
enemas8812003_enemas
epees75219833_epe_es
ephas10311543_ep_has
etas46432273___etas
fetas85624403__fetas
genets75716663genet_s
genevas1185253genevas
getas65421483__getas
hepcats1436473hepcats
heptad1237273hep_tad
heptads1335873hep_tads
impetus1144893impetus
keets95123483ke_et_s
leets54927123le_et_s
lepers84817323lepe_rs
lepta75714393lep_ta_
meets74224613me_et_s
melenas999203melenas
metepas1136303metepas
muletas937383muletas
nametag1044443nametag
nametags1143093nametags
napas75924353nap__as
napes74828463nape__s
naphthas1643253naphthas
nappas105511613nap_pas
neatens73310403neatens
neats55931903ne_at_s
nebulas957583nebulas
nectar838853ne_ctar
nectars938463ne_ctars
needs65719633ne_e_ds
neems77316293ne_e_ms
neeps75617883ne_e_ps
negates83215843negates
nemas75321573n__emas
nemeses948663nemeses
nemesis937373nemesis
nenes55329673nene__s
nepenthe1343543nepenthe
nepenthes1444163nepenthes
nephews1533323nephews
nepotic11310563nepotic
nepotism1246483nepotism
nepotist1059233nepotist
nereids838743nereids
nereis6315343nere_is
nerts55924983ne_rt_s
nesters74422793nesters
nests55728003ne_st_s
nets45941533n__et_s
netters73618583netters
netts55320723n__etts
neuters74212273neuters
neves87021873neve__s
newels93710823newe_ls
newts86015283ne_wt_s
nipas77116673nip__as
nonets64118703nonet_s
novenas1036893novenas
oedemas1056693oedemas
operas8312453_operas
peas65755063__pe_as
peats76140193__peats
pelotas9410723pelotas
peseta8310573peseta_
pesewas1236223pesewas
petal76526893__petal
petals84719813__petals
pets66248333__pet_s
pietas84516503_pietas
pipets105714773pipet_s
pitas77427673__pitas
reatas64021013re_atas
reheats104513523reheats
relets64025673relet_s
repeal84718283repe_al
repeals94014523repeals
repeat85127213repe_at
repegs93311943repe_gs
repels84318763repe_ls
repents93717623repents
reperks13298093reperks
repletes102812473repletes
repots85621003repot_s
reputes94615963reputes
reseats74319583reseats
resedas839123resedas
resets65427613reset_s
revets94022173revet_s
rewets94617213rewet_s
sapotas939613sapotas
segetal868383segetal
senecas939013senecas
senegas837253senegas
sepias83616103sep_ias
septa75518083sep_ta_
septal84513383sep_tal
septets998953septets
septs75420603sep_t_s
tapeta8310693tapeta_
tapetal938273tapetal
telegas837443telegas
temperas12278233temperas
tenets65518953tenet_s
tepas76521683tep__as
tepees84215243tepe_es
tephras1236283tephras
thetas93011573_thetas
veenas91410413ve_enas
vegetal1156303vegetal
veritas103012753veritas
vestas95916683ve_stas
weets85427723we_et_s
yentas94614213ye_ntas
zetas145018163__zetas

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271427.72017361.0
3Display Results1421420.0463087.0
 (SQL Overall)1786911428.17221866.3
 
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.