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

284 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
septics11281043(None) 
peptics132610241peptics
sceptics1455661sceptics
septic102713181septic_
skeptics1653861skeptics
aseptic1137372aseptic_
epics95014282_ep_ics
hepatics15198932hepatics
leptins92412692leptins
optics102810182_optics
peptic122113152peptic_
peptids12239322peptids
sceptic1337822sceptic_
sepias83616102sep_ias
sepic94617052sep_ic_
sepsis83011292sepsi_s
septets998952septets
septical1259362septical
septime1138782septime
septimes1238292septimes
septs75420602sept__s
septums1135742septums
skeptic1545192skeptic_
spics94123242s_p_ics
statics93314532statics
styptics1543812styptics
antics84621453_antics
arctics1138953arctics
ascetics1247073ascetics
asepsis985903asepsi_s
aspics104211563asp_ics
attics84413283_attics
bedtick1645233bedtick
bedticks1774163bedticks
bestirs9311133bestirs
beylics1436183beylics
biotics113812173biotics
bustics11810883bustics
clitics11279973clitics
cretics112911653cretics
critics112811093critics
deictics1345563deictics
deities82621923deities
deltic9312503deltic_
demotics1338753demotics
dentils84115583dentils
dentins83419223dentins
depict113514793dep_ict
depicts12358463dep_icts
depths12428573dept_hs
deputies1157533deputies
detick1339383de_tick
deticks1437353de_ticks
dyspeptics2052403dyspeptics
emetics11610723emetics
empties11712243empties
emptins1179403emptins
entice81316863_entice
entices91616333_entices
epic86921303_ep_ic_
erotics91914153erotics
espies83716803esp_ies
esprits938393esprits
ethics11169283_ethics
etic66123953_e_tic_
exotics16229193exotics
fetich1479693fe_tich
fustics1279593fustics
genetics11128613genetics
gestic9312773gestic_
glyptics1643103glyptics
haptic13511883haptic_
hectic132311513hectic_
hematics151712193hematics
hepatic141712773hepatic_
hepatica15177593hepatica
hepaticas16166583hepaticas
heptads1335873heptads
herdics13249523herdics
heretics13310503heretics
heroics122912003heroics
jetties143613123jetties
kepis115313363kep_i_s
lectins92515003lectins
lefties10312073lefties
lentic83515743lentic_
lentils73912973lentils
leptin82512333lepti_n
leptons91910413leptons
luetics937323luetics
mastics112614783mastics
medics114115353me_dics
memetics1447803memetics
metis75025903me_ti_s
metrics11312363metrics
miotics112710653miotics
myotics14257593myotics
mystics14279103mystics
nepotic11310553nepotic_
optic93715183_optic_
pectic122913873pectic_
pectins112315233pectins
pelvics14245643pelvics
pepsins11310433pepsins
peptid112712373pepti_d
peptide122910683peptide
peptides132610253peptides
peptize20279483peptize
peptizes21269853peptizes
photics142810473photics
pics85633913__p_ics
poetics11312073poetics
relics84517903re_lics
repairs9319973repairs
repins84924313rep_ins
replica1137943replica
replicas1237093replicas
replies94521043replies
reprice113212833reprice
reprices122913353reprices
reptile93914083reptile
reptiles103913063reptiles
reties65436193re_ties
rustics9810733rustics
salties73725773salties
santims9312593santims
santirs7312963santirs
sapphics1743413sapphics
satins64930483s_atins
satis55633673s_ati_s
scenics1137773scenics
scepters1237783scepters
sceptical1545343sceptical
scepticism1873903scepticism
sceptres1244993sceptres
schtick18194523schtick
schticks19193953schticks
schtiks16184743schtiks
sciatics12117273sciatics
scotias939733scotias
seasick1346193seasick
seaters74028933seaters
seating84130683seating
seatings93614293seatings
seats54844343seat__s
secs65033893se___cs
sectile9311973sectile
section92515663section
sections102714703sections
sectors93116433sectors
sects75622893sect__s
seethes103613743seethes
seifs85019333se__ifs
seis45542393se__i_s
seisins73614393seisins
seitans73312303seitans
seizins164010133seizins
selkies113513353selkies
semantics1346823semantics
sematic111716863sematic_
semiotics1376913semiotics
semis74623533se_mi_s
semplice1447013semplice
sennits73811283sennits
senti56226693senti__
sentimo9449613sentimo
sentimos10407423sentimos
sentries81318053sentries
sepals85217373sep_als
sepia75318673sep_i_a
sepoys1138473sep_oys
sepses84515883sep_ses
sept65844363sept___
septa75518083sept__a
septage1078403septage
septages1168263septages
septal84513383sept_al
septate9511873septate
septet8921133sept_et
septicity1646583septicity
septum1037993sept_um
sequins1637863sequins
seracs84418573se_racs
serails73318363serails
serais64326133serai_s
sereins73716113sereins
series64540973se_ries
serifs94017053se_rifs
serins64029673se_rins
serries73925353serries
service1239083service
services1338573services
sestets7911473sestets
sestina72711973sestina
sestinas8249133sestinas
sestine73017923sestine
sestines82717243sestines
setons64620173se_tons
setous64917373se_tous
sets45549503se_t__s
settees73513633settees
setters73822063setters
setting83621393setting
settings93810073settings
settles73916003settles
setts55124323se_t_ts
setups83910463se_tups
sextains15246813sextains
sextans14349263sextans
sextets1497143sextets
sextile1438573sextile
sextiles1537643sextiles
sextons143710413sextons
sextos134012163sext_os
sexts125118383sext__s
sferics1236133sferics
shelties111111373shelties
shtick15308013s_htick
shticks16356963s_hticks
shtiks13297823s_htiks
sics65234093s___ics
silvics1235563silvics
sixties14310973sixties
skepsis1344243skepsi_s
skeptical1743963skeptical
skepticism2072923skepticism
smectic1336603smectic_
softies103414613softies
sonics84315633s_onics
sophies12314603sophies
sopites93817173sopites
sorties74126403sorties
spails84817823s_pails
spaits85017473s_paits
spastics1237503spastics
species11314133species
specs96916673s_p_ecs
speils84116223s_peils
speirs85013233s_peirs
speiss84311643s_peiss
spic85227433s_p_ic_
spica94717943s_p_ica
spicas104715823s_p_icas
spice95528813s_p_ice
spices104326033s_p_ices
spick134519073s_p_ick
spicks144814993s_p_icks
spicy125417713s_p_icy
spies76037623s_p_ies
spiks114117473s_p_iks
spins75327983s_p_ins
spites84127333s_pites
spits74429553s_p_its
spivs105114243s_p_ivs
splice104915103s_plice
splices113914383s_plices
splits85416413s_plits
spoils84614533s_poils
sprigs94814773s_prigs
sprits85122533s_prits
static83118673static_
statice92614033statice
statices102712343statices
statins73719773statins
stich104117923s__tich
stichs114511653s__tichs
stick115121563s__tick
sticks125118613s__ticks
sties55132983s__ties
stirs55921613s__tirs
stoics8311113s_toics
stotins73213863stotins
styptic1445443styptic_
sweeties11159723sweeties
syndics1335703syndics
tactics1149323tactics
testis64916713testi_s
tics65729633___tics
topics104714583top_ics
uptick1436763_uptick
upticks1535153_upticks
vertices13612273vertices
yetis85418393ye_ti_s
zeatins16311733zeatins

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.1561145455.1
2DLD Change Limit1340272848.53315706.9
3Display Results2842840.0933053.8
 (SQL Overall)1786912848.78220347.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.