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

417 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
active1131374(None) 
actives12311521actives
achieve1545022achieve
actin74922552acti_n
acting95920982acting
actins86321102actins
action84719682action
activate13510372activate
actively1647062actively
activize2246612activize
alive85722512a_live
amative12311732amative
archive154610482archive
arrive91311792arrive
attire62412382attire
captive1438972captive
chive135117622_chive
coactive1598622coactive
dative10311812dative
enactive1338512enactive
fictive1537022fictive
inactive1348202inactive
motive113112142motive
native9613012native
octave11157342octave
reactive13310472reactive
scrive115414942scrive
tactile9310612tactile
tractive13310042tractive
votive12348932votive
abide86223713a_bide
ablative1348243ablative
abortive1346883abortive
above105414323a_bove
abusive1245283abusive
acarine9316003acarine
accede1138303accede
acceptive1845083acceptive
accidie1247733accidie
accretive1645093accretive
accrue1035823accrue
accuse103411033accuse
ace59656833ac___e
acetate92514753acetate
acetic10314503aceti_c
acetify1545003acetify
acetin8314693aceti_n
acetins9313173acetins
acetone9310793acetone
acetose938843acetose
ache96829823ac__he
achene11313813achene
achier113914263achier
achieved1743713achieved
achiever1643843achiever
achieves1645523achieves
aching126521973aching
achiote1239213achiote
acid77533393ac_i_d
acids87121003ac_ids
acidy117214893ac_idy
acing87429153ac_ing
acini75718983ac_ini
ackee115825373ac_kee
acme86924323ac__me
acmic11312333acmi_c
acne66625873ac__ne
acnode938203acnode
aconite9315473aconite
acquire1835603acquire
acre67330773ac__re
acrid86920103acri_d
acrider1038623acrider
act59557843act___
acta69524803act__a
actable11313473actable
acted88521733act_ed
actinal9312293actinal
actings104512463actings
actinia91710863actinia
actiniae101810023actiniae
actinic111810563actinic
actinide11199213actinide
actinon9459463actinon
actioner1048663actioner
actions94218513actions
activated1567883activated
activates1449683activates
activism15117083activism
activist13109483activist
activity1647593activity
activized2445203activized
activizes2346323activizes
actor71116083act_or
actors81016773actors
acts66929863act__s
actual8311023actual
actuate9311443actuate
acuate8315633acuate
acuity1139373acuity
acute74720363ac_ute
adaptive1445133adaptive
addictive1644563addictive
additive1345863additive
adductive1643963adductive
adjective2244813adjective
admire949933admire
adoptive1445503adoptive
advective1845233advective
advice12107883advice
advise10139223advise
aedile73716653aedile
aedine73218393aedine
aerie54634603aeri_e
affective20135413affective
affine12310503affine
afire86215913a_fire
agatize1739833agatize
agave95314033a_gave
agentive1248043agentive
aggie73415013aggi_e
agile65122263a_gile
agnize16329563agnize
aide56045003a__ide
airtime948063airtime
aiver85725163a__iver
ajiva1586803a_jiva
albite8313313albite
alcaide1088453alcaide
alcove1178093alcove
alike95523963a_like
aline57243153a_line
alkie95520033alki_e
alkine104916803alkine
alpine84417373alpine
alsike1047913alsike
alvine94614583alvine
amice96122873a_mice
amide86128483a_mide
amie66339853a_mi_e
amine75835383a_mine
ammine10314493ammine
amusive1246253amusive
anile54634463a_nile
anime75423203a_nime
anise55129703a_nise
antae56828293ant_ae
ante46538903ant__e
anti45536363anti__
antiar6317173antiar
antic75728863anti_c
antick124814583antick
antics84621453antics
antigen8311123antigen
anting75827023anting
antique1638883antique
antired82316193antired
antis55033313anti_s
antisex1439693antisex
antlike11312073antlike
antre55224523ant_re
anytime1246043anytime
apatite9312963apatite
aplite8316393aplite
aquiver1934753aquiver
archine125817053archine
archived17355993archived
archives16399553archives
arcsine94512393arcsine
arctic10313513arcti_c
arctics1138953arctics
arise56436433a_rise
arrived11127353arrived
arriver10117793arriver
arrives101311513arrives
arsine64021043arsine
article9310923article
artier63419733artier
artily92814713artily
artist64125543artist
artiste73813693artiste
ascribe1147743ascribe
aside65122083a_side
aspire8612123aspire
assize1538633assize
astilbe945653astilbe
astir55517093asti_r
astride8311973astride
astute6310763astute
ate37059243a_t__e
atilt54828473a_tilt
atone56527983a_tone
attic75618353atti_c
attics84413283attics
attired8238913attired
attires72312953attires
attrite7311833attrite
attune637983attune
auction93412933auction
audile73315303audile
auditive1247163auditive
augite7312613augite
auntie64317703aunti_e
autism83815333autism
autist64324943autist
ave67748703a___ve
awhile1257793awhile
axile126020513a_xile
axite125218253a_xite
axlike17388853axlike
azide155617163a_zide
azine146721413a_zine
azotise1637073azotise
azotize1537083azotize
baptise1139553baptise
baptize2036983baptize
bastile9313913bastile
bawtie113812143bawti_e
belive115415303belive
betide95115973betide
betime105914833betime
betise85616273betise
bioactive1644133bioactive
cacti9318643cacti__
calve105919923_calve
camise103319633camise
canine83826703canine
captives1538623captives
caribe103416753caribe
carve106227753_carve
cate66254603cat__e
cation83925503cation
catlike132712933catlike
cattie85221023cattie
cattle85118903cattle
cave95941263_c_ave
cavie104621593cavi_e
chide115321013_chide
chile105626893_chile
chime125322593_chime
chine105231723_chine
chives144317593_chives
chivy164810363_chivy
cine66242943_c_ine
cire65836373_c_ire
cite65640343_c_ite
civet105828733_c_ivet
civie103716353_c_ivie
clave105420153_clave
clime95720893_clime
cline76428533_cline
clove105619443_clove
costive12312843costive
cove95837073_c_ove
crave105626313_crave
crime94822693_crime
cripe95521143_cripe
curve104920023_curve
cutie76925933cuti_e
dacite91115883dac_ite
datives11310073datives
dautie72914703dauti_e
dawtie103011093dawti_e
daytime1344783daytime
deceive1337813deceive
derive103817043derive
dive85634773__dive
drive95318003_drive
ductile1048483ductile
ectype1334283ectype
eductive1476863eductive
ejective2037153ejective
elative10312453elative
elective13311003elective
emotive1239193emotive
endive103310473endive
entice81316863entice
entire61617703entire
erective13311833erective
exaptive2045253exaptive
facetiae1346213facetiae
faciae112913413fac_iae
facile112514883fac_ile
faction122613333faction
factitive1745033factitive
facture12108943facture
festive1339773festive
fictile1238023fictile
five107629743__five
furtive1337173furtive
futile93914953futile
give85829353__give
glaive10357933glaive
hackie154615623hacki_e
hive106029673__hive
ictic9311803icti_c
impactive1845283impactive
intime81014273intime
intine61021983intine
jive146123593__jive
lactase937963lactase
lactate9312703lactate
lactic10713493lacti_c
lactone9311413lactone
lactose969493lactose
lattice938433lattice
laxative1845093laxative
live76540993__live
locative1338683locative
machine14313493machine
massive12289773massive
motile83818343motile
motived13357763motived
motives123611893motives
mutine84420373mutine
naive85116213_naive
natives10310823natives
nonactive1448973nonactive
notice8313443notice
octane81411633octane
octaves12316963octaves
octavo11124783octavo
ogive9379093_ogive
olfactive1743463olfactive
olive84817153_olive
optime1079353optime
orective1339353orective
outgive11199253outgive
outlive102513033outlive
outvie92412803outvie
paction112713963paction
pantie84326473panti_e
pantile93918483pantile
partite9317133partite
passive12239593passive
pastie85525523pasti_e
pastime114611973pastime
patine85328123patine
pattie84020963patti_e
pectize20259913pectize
petite84320653petite
placative1646223placative
practice1438733practice
practise12310143practise
proactive1648363proactive
ragtime1036163ragtime
ratine65131823ratine
ratite65022423ratite
receive1239733receive
regive104814323regive
reive85522943_reive
relive95120783relive
restive10315933restive
retie55735303reti_e
retile65929673retile
retime85321803retime
retine66237333retine
retire64927013retire
revive124914823revive
rive75537723__rive
rutile65217683rutile
saclike131210123saclike
saltie63422433salti_e
saltine75018563saltine
saltire73113043saltire
sanative11310473sanative
satire63218003satire
scribe104613533scribe
scrieve12448333scrieve
scrived134511113scrived
scrives124414273scrives
sectile9311973sectile
shive114423423_shive
shrive125216953shrive
skive124614113_skive
stative102612933stative
stave85324993_stave
stile54931573_stile
stime76521803_stime
stipe76523373_stipe
stiver93915733_stiver
stove85220253_stove
strive95020963strive
swive115316193_swive
tacrine9311293tacrine
tactic10612753tacti_c
tactics1149323tactics
taction93213023taction
tantivy1335563tantivy
tardive1136893tardive
tattie64817513tatti_e
tectite9310583tectite
thrive125313223thrive
tide55237383__tide
tie36557533__ti_e
tike85534483__tike
tile45451443__tile
time66235013__time
tine45855133__tine
tire46143353__tire
tivy1014516863__tivy
tractile10311073tractile
unitive10310563unitive
unlive92712333unlive
untie54425493unti_e
updive1234903updive
uptime1067673uptime
utile54718933_utile
vaccine1437323vaccine
vetiver1336103vetiver
visive1257873visive
vive105426623__vive
vocative1637913vocative
votives13337953votives
waive114214603_waive
wartime1237743wartime
wive105931753__wive

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 Filter1786911127160.766233278.1
2DLD Change Limit1127164176.43617513.4
3Display Results4174170.1402978.6
 (SQL Overall)1786914177.34224338.2
 
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.