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

299 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
pactions12261350(None) 
actions94218511_actions
factions133013061factions
paction112713961paction_
tactions102912421tactions
actinons10389452_actinons
actins86321102_acti_ns
action84719682_action_
auctions104012142auctions
bastions10411692bastions
captions123813222captions
cations94524142ca_tions
cautions103313182cautions
coactions1349742coactions
dictions111812672dictions
exactions1838922exactions
faction122613332faction_
factious13239242factious
fictions132410742fictions
fractions1449102fractions
impactions1645412impactions
inactions1139322inactions
kations114013662ka_tions
lections102413842lections
nations74720562na_tions
partons94620512part_ons
passions10310582passions
patins87528782pa_ti_ns
patios85221782pa_tio_s
patrons93818102pa_trons
pectins112315232pecti_ns
placations1438582placations
portions10514412portions
potions93417422p_otions
proactions1449342proactions
rations74123432ra_tions
reactions11711712reactions
ructions102811682ructions
sanctions1138872sanctions
sections102714702sections
suctions103012902suctions
taction93213022taction_
tractions11511622tractions
unctions1039732unctions
vacations141910552vacations
acetins9313173_aceti_ns
actin74922553_acti_n_
acting95920983_acti_ng
actings104512463_actings
actinon9459463_actinon
actioner1048663_actioner
actioners1147723_actioners
actives12311523_actives
actors81016763_act_ors
adaptions1245223adaptions
alations82518893alations
amnions93710913_amnions
amotions1069843amotions
anions64123033_a_nions
antlions839193_antlions
auction93412933auction_
avions94114393_a_vions
axions134713483_a_xions
bacons104917583bac__ons
basions94213953ba_sions
bastion9312473bastion_
batons85519423ba_t_ons
camions113916133ca_mions
campions143511293campions
cantons95221203cant_ons
caption113513693caption_
captious122810573captious
carrions10312453carrions
cartons94122473cart_ons
cartoons104012803cartoons
cation83925503ca_tion_
caution93013523caution_
cautious103110233cautious
cions75222853__c_ions
coaction12310773coaction_
coitions10312853coitions
compactions1946533compactions
dacrons103211033dac_rons
daltons8310403dalt_ons
depictions1546893depictions
diction102313053diction_
editions9310403editions
eductions1268773eductions
ejections18249963ejections
elations83719123elations
elections112414973elections
elutions82513053elutions
emotions10610283emotions
enations83316903enations
erections112515213erections
evections142510693evections
evictions14228623evictions
exaction1738953exaction_
excitons1746043excitons
facetious1464443facetious
factional1478763factional
factoids1446243factoids
factors12912123fact_ors
falchions1743913falchions
fanions103713073fa_nions
fashions1437243fashions
fiction122010733fiction_
flections14239213flections
fraction1359483fraction_
fractious1456143fractious
frictions1448033frictions
functions1437743functions
gabions102410053ga_bions
halations12312393halations
impaction1545733impaction_
inaction1039623inaction_
jactations1936893jactations
junctions1835943junctions
kation104315683ka_tion_
lactations1239423lactations
lacteous1046773lacteous
lactone9311393lact_one
lactones10311223lact_ones
lampions12277973lampions
latinos73613803la_tinos
lattins74115483latti_ns
lavations1238973lavations
laxations1637623laxations
lectins92515003lecti_ns
lection92614863lection_
locations112512743locations
locutions11207063locutions
lotions74614763_lotions
macons104017243mac__ons
macrons113514893mac_rons
mansions1069793mansions
martians103111613martians
martins93322063marti_ns
matins84527783ma_ti_ns
matrons93517633ma_trons
mattins93316143matti_ns
mentions10312893mentions
motions94215003_motions
nasions73112383na_sions
natations91412493natations
nation64322803na_tion_
natrons73215663na_trons
nonactions1248373nonactions
notions74014483_notions
olfactions1563873olfactions
options93810603_options
orations81515803orations
ovations11149263ovations
pachisis15268823pachisis
pacing114522753pac_i_ng
packing164420723packi_ng
packings174310063packings
pacts95125803pact___s
paeons83915523pa__eons
pains75138283pa__i_ns
palmations1438733palmations
palpations1437653palpations
pantheons1446513pantheons
panties94230933panti_es
pantiles103617153pantiles
panting104025423panti_ng
pantos85222743pant_o_s
papains11312363papai_ns
paphians1545593paphians
paragons11311503paragons
parathions1545323parathions
pardons103817623pa_rdons
parians93519733pa_rians
parsons93516873pa_rsons
partans94418283part_ans
partials101911953partials
partiers103514243partiers
parties93230863parti_es
parting103527383parti_ng
partings113513733partings
partisans1167483partisans
partitas10310253partitas
partitions1248323partitions
partizans2055243partizans
parton84720993part_on_
passion9310883passion_
pasterns104112623pasterns
pasties94529813pasti_es
pastils94416173pasti_ls
pastimes123611903pastimes
pastina93914593pasti_na
pastinas103712153pastinas
pasting103826553pasti_ng
pastis84924323pasti__s
pastises103616053pastises
pastors94119003past_ors
patens84820863pa_t_ens
pathos115516693pa_tho_s
patient9617073pa_tient
patients1088763pa_tients
patin76832853pa_ti_n_
patina86022193pa_ti_na
patinas96318523pa_tinas
patine85328123pa_ti_ne
patines95225763pa_tines
patio74426353pa_tio__
patois84319363pa_t_ois
patriots1038053patriots
patrols93513513pa_trols
patron84018043pa_tron_
patroons102710603patroons
pattens95414923pa_ttens
patterns10439943patterns
patties93425143patti_es
patting103722343patti_ng
paulins9312613pauli_ns
pavilions1444793pavilions
pavins114919663pa_vi_ns
paviors1237603pa_viors
pectens11189203pect_ens
pectin102615533pecti_n_
pectines121914683pectines
pectinous1345553pectinous
pectizes21229783pectizes
pensions10311693pensions
pereions10310853pereions
petitions11511083petitions
phaetons1345853phaet_ons
photons123814433phot_ons
phytins15317893phyti_ns
phytons15319063phyt_ons
pillions101610923pillions
pinions93413603p_inions
pions75826393p___ions
pistons93016373pist_ons
pitons85319043p_it_ons
placation1339773placation_
planations1238723planations
plastrons1147133plastrons
platoons1038683platoons
plectrons13258073plectrons
plications14310493plications
plosions1038023plosions
plutons938343plut_ons
pocosons1266103pocosons
pontons93315553pont_ons
pontoons10279313pontoons
portion9615493portion_
positions11811503positions
postins93721203posti_ns
potations111615073potations
potion84519573p_otion_
practices1557993practices
practises1349623practises
prions84317783p__rions
proaction13410103proaction_
protons93118003prot_ons
puccoons1443403puccoons
pulsions1037713pulsions
punitions1137923punitions
pupations1338123pupations
putons83515153p_ut_ons
pythons1537363p_ythons
raccoons1265453raccoons
racons84319343rac__ons
racoons93912433rac_oons
rampions12248023rampions
ration64226013ra_tion_
ratios64922673ra_tio_s
ratoons73815473ra_toons
rattons73815323ra_ttons
rattoons8327513rattoons
reaction10612603reaction_
redactions1359133redactions
ruction93611613ruction_
ructious10277083ructious
sacatons1038973sacatons
sanction1049533sanction_
satins64930483sa_ti_ns
scions82612243_sc_ions
section92515663section_
spacious1237813spac_ious
stations82415223stations
stictions1148353stictions
suction93713043suction_
tachyons1644623tachyons
tactics1149323tacti_cs
talions7314103ta_lions
tampions12358113tampions
taxations1636863taxations
traction10412683traction_
tuitions838283tuitions
unction9310663unction_
vacation131911893vacation_
vocations141911423vocations
waitrons1136633waitrons
wanions104011373wa_nions
wantons103713013want_ons
zacatons1945703zacatons

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622997.82618676.5
3Display Results2992990.1102718.2
 (SQL Overall)1786912998.09222082.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.