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

164 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
exactions183892(None) 
exaction1738951exaction_
actions94218512__actions
coactions1349742coactions
eductions1268772eductions
ejections18249962ejections
elations83719122ela_tions
elections112414972elections
enations83316902ena_tions
erections112515212erections
evections142510692evections
evictions14228622evictions
exacting1838522exacti_ng
exactors1737012exact_ors
excitons1746042ex_citons
executions1946392executions
exertions1639762exertions
exsections1947632exsections
extractions2077742extractions
factions133013062_factions
fractions1449102fractions
inactions1139322inactions
pactions122613502_pactions
reactions11711712reactions
redactions1359132redactions
tactions102912422_tactions
tractions11511622tractions
vexations1937752vexa_tions
actinons10389453__actinons
actins86321103__acti_ns
action84719683__action_
adaptions1245223adaptions
aerations9317903aera_tions
alations82518893ala_tions
auctions104012143_auctions
bastions10411693_bastions
captions123813223_captions
cations94524143_ca_tions
cautions103313183_cautions
coaction12310773coaction_
decoctions1547143decoctions
deductions1467133deductions
defections161510203defections
dejections20168353dejections
delations102616593dela_tions
depictions1546893depictions
detections131410043detections
detractions14118273detractions
dictions111812673_dictions
edacious1146023edac_ious
editions9310403e_ditions
educations1339233educations
eduction1169053eduction_
egestions1046703egestions
ejection172510043ejection_
elastins82111743elasti_ns
elation73620453ela_tion_
election102015353election_
electrons112411753electrons
elocutions1245963elocutions
elutions82513053e_lutions
emaciations1548163emaciations
emanations1289593emanations
emotions10610283e_motions
enacting11311363enacti_ng
enactors1038453enact_ors
enation73419233ena_tion_
equations1839493equations
erasions8310983era_sions
erection102115513erection_
eruptions1146763eruptions
evacuations1646303evacuations
evasions1136543eva_sions
evection131910833evection_
eviction13228683eviction_
evocations15259873evocations
exactas16336433exact__as
exacters1736773exact_ers
exactness1843623exactness
exactor1636623exact_o_r
exacts15359613exact___s
exaltations1847293exaltations
exalting1638033exalti_ng
excavations2345083excavations
exceptions2146863exceptions
excisions1846383excisions
exciton1646083ex_citon_
excitors1746093ex_citors
excretions1946623excretions
execrations2048923execrations
execution1846303execution_
exemptions2164833exemptions
exertion15310083exertion_
exhalations2146023exhalations
exhaustions2153123exhaustions
expansions1944153expansions
expiations1959663expiations
expunctions2243633expunctions
exsection1847493exsection_
exsertions1746743exsertions
extinctions2044633extinctions
extortions1746473extortions
extraction1967983extraction_
exudations18107073exudations
faction122613333_faction_
factious13239243_factious
fetations12511383feta_tions
fictions132410743_fictions
fixations1936353fixa_tions
flections14239213flections
fraction1359483fraction_
fractious1456143fractious
frictions1448033frictions
functions1437743functions
gelations102513093gela_tions
impactions1645413impactions
inaction1039623inaction_
junctions1835943junctions
kations114013663_ka_tions
laxations1637623laxations
lections102413843_lections
legations102711923lega_tions
locations112512743locations
luxations1637273luxa_tions
nations74720563_na_tions
negations102811963nega_tions
nonactions1248373nonactions
olfactions1563873olfactions
orations81515803ora_tions
ovations11149263ova_tions
overactions1648213overactions
paction112713963_paction_
placations1438583placations
proactions1449343proactions
rations74123433_ra_tions
reaction10612603reaction_
recautions1247813recautions
redaction1259663redaction_
reductions1359583reductions
refections151811643refections
refractions16127723refractions
rejections191510103rejections
relations92418333rela_tions
relictions12310023relictions
resections121513033resections
retractions13910353retractions
ructions102811683_ructions
sanctions1138873sanctions
sections102714703_sections
sedations10311253seda_tions
seductions1366873seductions
selections12310873selections
stations82415223sta_tions
stictions1148353stictions
suctions103012903_suctions
taction93213023_taction_
taxations1636863taxations
traction10412683traction_
unctions1039733_unctions
vacations141910553_vacations
venations12311723vena_tions
vexation1838783vexa_tion_
vexatious1944103vexa_tious
vocations141911423vocations

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411646.11024327.5
3Display Results1641640.0802050.0
 (SQL Overall)1786911646.59627090.8
 
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.