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

279 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
taction9321302(None) 
action84719681_action
faction122613331faction
paction112713961paction
tactions102912421tactions
traction10412681traction
actin74922552_acti_n
actinon9459462_actinon
actions94218512_actions
auction93412932auction
bastion9312472bastion
caption113513692caption
cation83925502ca_tion
caution93013522caution
coaction12310772coaction
diction102313052diction
exaction1738952exaction
factions133013062factions
fiction122010732fiction
fraction1359482fraction
inaction1039622inaction
kation104315682ka_tion
lection92614862lection
nation64322802na_tion
pactions122613502pactions
ration64226012ra_tion
reaction10612602reaction
ruction93611612ruction
sanction1049532sanction
section92515662section
station72717242sta_tion
stiction1038822stiction
suction93713042suction
tachyon1544622tachyon
tactic10612752tacti_c
tactics1149322tactics
tactile9310612tactile
talion6317712ta_lion
tampion11298662tampion
taxation1537992taxation
tractions11511622tractions
tuition738822tuition
unction9310662unction
vacation131911892vacation
acetin8314693_aceti_n
acting95920983_acting
actinons10389453_actinons
actins86321103_actins
actioner1048663_actioner
active11313743_active
actor71116073_act_or
adaption1145643adaption
alation72920553alation
amnion84812053_amnion
amotion9710473amotion
anion55028813_a_nion
antlion7310293_antlion
atactic11410083atacti_c
attraction1276953attraction
auctions104012143auctions
avion84218343_a_vion
axion1211316913_a_xion
bacon95620593bac__on
basion84315853ba_sion
bastions10411693bastions
baton75822423ba_t_on
cacti9318643cacti__
cactoid12311033cactoid
camion103917193ca_mion
campion133011413campion
canton85722993cant_on
captions123813223captions
carrion9312673carrion
carton84522663cart_on
cartoon94114463cartoon
cations94524143ca_tions
cautions103313183cautions
cion613330913__c_ion
citation10314363cita_tion
coactions1349743coactions
coition9314313coition
dacron94310693dac_ron
dalton7311273dalt_on
detection121310413detection
detraction13138583detraction
dictions111812673dictions
dotation91412733dota_tion
edition8310853edition
eduction1169053eduction
ejection172510043ejection
elation73620453elation
election102015353election
elution72913823elution
emotion9711303emotion
enation73419233enation
erection102115513erection
evection131910833evection
eviction13228683eviction
exactions1838923exactions
exciton1646083exciton
extraction1967983extraction
factional1478763factional
factious13239243factious
factoid1338693factoid
factor11911453fact_or
falchion1644343falchion
fanion94514323fa_nion
fashion1337843fashion
fetation11613143feta_tion
fictions132410743fictions
flection13239563flection
fractions1449103fractions
friction1347913friction
function1337843function
gabion93211033ga_bion
halation11313853halation
impaction1545733impaction
inactions1139323inactions
jactation1838143jactation
junction1736203junction
kations114013663ka_tions
lactation11310813lactation
lactean956473lactean
lactic10713493lacti_c
lactone9311393lact_one
lampion11278303lampion
latino64120473la_tino
lattin64316223latti_n
lavation1139973lavation
laxation1538423laxation
lectin82515013lecti_n
lections102413843lections
location102113913location
locution10227663locution
lotion65716523_lotion
macon94519953mac__on
macron103615673mac_ron
mansion9611543mansion
martian93514683martian
martin84122523marti_n
matin75132853ma_ti_n
matron83918313ma_tron
mattin84416633matti_n
mention9314373mention
motion85217553_motion
mutation101412883muta_tion
nasion63914083na_sion
natation81513933natation
nations74720563na_tions
natron64116023na_tron
nonaction1149443nonaction
notation81414603nota_tion
notion64516583_notion
nutation81513103nuta_tion
olfaction1464233olfaction
option83612713_option
oration71617713oration
ovation101510023ovation
parton84720993part_on
passion9310883passion
patin76832853pa_ti_n
patio74426353pa_tio_
patios85221783pa_tios
patron84018043pa_tron
pectin102615533pecti_n
placation1339773placation
portion9615493portion
potation101716783pota_tion
potion84519573_potion
proaction13410103proaction
raccoon1176163raccoon
racon75422143rac__on
racoon83814473rac_oon
rampion11298583rampion
ratio55227583ra_tio_
rations74123433ra_tions
ratios64922673ra_tios
ratoon64417373ra_toon
ratton64116123ra_tton
rattoon7359243rattoon
reactions11711713reactions
redaction1259663redaction
retraction121310533retraction
rotation81615453rota_tion
ructions102811683ructions
sacaton938993sacaton
sanctions1138873sanctions
satin55935223sa_ti_n
scion72214993_sc_ion
sections102714703sections
stallion837513stallion
stanchion1444643stanchion
statin63921473sta_ti_n
stations82415223sta_tions
stictions1148353stictions
striction1148983striction
suctions103012903suctions
tachism1478873tachism
tachist12613293tachist
tachyons1644623tachyons
tacit76333673tac_i_t
tacitly1236223tacitly
taciturn1042653taciturn
tackier133712523tackier
tackify1934493tackify
tackily1637503tackily
tacking144421483tacking
taco67031353tac__o_
tacos77023553tac__os
tacrine9311293tacrine
tact67349033tact___
tactful1236163tactful
tactical1248843tactical
tactician1345673tactician
tacts76524123tact__s
tactual936203tactual
tain45548073ta__i_n
takin94921303ta_ki_n
talions7314113ta_lions
talon55824113ta__lon
tamein8313093tamei_n
tampions12358123tampions
tampon102911233ta_mpon
tannin62613923tanni_n
tantivy1335563tantivy
tanto55724943tant_o_
tardyon1134673tardyon
tarnation9310093tarnation
tarpon82812803ta_rpon
tartan64217513tart_an
tartier74123263tartier
tartily103511573tartily
tarting84222653tarting
tartish101512633tartish
tastier711817093tastier
tastily103311643tastily
tasting84624213tasting
tatsoi637263ta_tsoi
tattie64817513tatti_e
tattier74216243tattier
tatties74120343tatties
tattily10409993tattily
tatting84019523tatting
tattoo6310973ta_ttoo
tattoos738643tattoos
tauon54816583ta__uon
tauten64311893taut_en
tauting83316383tauting
tautog765713taut_og
taxations1636863taxations
taxon124414663ta__xon
tectite9310583tectite
tension7311803tension
ternion739493ternion
tertian7511193tertian
teston6313303test_on
testoon748373testoon
tictoc1036003tict_oc
titian62512663t_itian
tocsin8311003tocsi_n
tompion11247103tompion
torsion7310803torsion
tractile10311073tractile
tractional1248053tractional
tractive13310043tractive
tractor9311333tract_or
tradition1047593tradition
trajection1944693trajection
triton63914893trit_on
tuitions838283tuitions
turion6313163t_urion
tycoon1136023tyc_oon
unctions1039733unctions
vacations141910553vacations
vocation132311983vocation
waitron1036333waitron
wanion93213063wa_nion
wanton94413813want_on
zacaton1845633zacaton

Search took 7 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.410435831.7
2DLD Change Limit1340272796.18621666.2
3Display Results2792790.0933000.0
 (SQL Overall)1786912796.68926714.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.