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

139 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
sanctions113887(None) 
sanction1049531sanction_
actions94218512_a_ctions
auctions104012142_auctions
factions133013062fa_ctions
functions1437742functions
inactions1139322inactions
junctions1835942junctions
pactions122613502pa_ctions
sanctimony1751642sanctimony
sanctioned1343902sanctioned
sections102714702s_ections
stanchions1543662stanchions
stictions1148352stictions
suctions103012902s_uctions
tactions102912422ta_ctions
unctions1039732_unctions
actinons10389453_a_ctinons
actins86321103_a_cti_ns
action84719683_a_ction_
adnations1039753adnations
agnations10310033agnations
alations82518893_alations
amotions1069843_amotions
anions64123033_an__ions
antlions839193_antlions
auction93412933_auction_
bastions10411693ba_stions
cantons95221203can_t_ons
captions123813223ca_ptions
carnations12311353carnations
cations94524143ca__tions
cautions103313183ca_utions
coactions1349743coactions
conations111318903conations
damnations1337083damnations
darnations1138413darnations
dictions111812673_dictions
donations101112353donations
eductions1268773eductions
ejections18249963ejections
elections112414973elections
emanations1289593emanations
enations83316903_enations
erections112515213erections
evections142510693evections
evictions14228623evictions
exactions1838923exactions
faction122613333fa_ction_
factious13239243fa_ctious
falchions1743913falchions
fanions103713073fan__ions
fictions132410743_fictions
flections14239213flections
fractions1449103fractions
frictions1448033frictions
function1337843function_
ganglions1144063ganglions
halations12312393halations
ignitions1045803ignitions
inaction1039623inaction_
inanitions1046383inanitions
inunctions1246753inunctions
junction1736203junction_
kations114013663ka__tions
lavations1238973lavations
laxations1637623laxations
lections102413843_lections
lenitions939473lenitions
lunations9310723lunations
mansions1069793man_sions
mentions10312893men_tions
monitions11310883monitions
munitions1138173munitions
natations91412493natations
nations74720563__nations
nonactions1248373nonactions
notions74014483__notions
paction112713963pa_ction_
planations1238723planations
punitions1137923punitions
rations74123433ra__tions
reactions11711713reactions
ructions102811683_ructions
sabatons1037843sabat_ons
sacatons1038973sa_catons
saltations10310623saltations
salvations1338133salvations
sanctifies1554983sanctifies
sanctify1644493sancti_fy
sanctimonies1652203sanctimonies
sanctioning1453993sanctioning
sanctities1247553sanctities
sanctity1345593sancti_ty
sanctums1244013sanct_ums
sanious7514103san__ious
sanitations11410843sanitations
sanities81219773saniti_es
sanitises91111743sanitises
sanitizes181210133sanitizes
santims9312603san_ti_ms
santirs7312963san_ti_rs
santols73513323san_t_ols
santoors837633san_toors
santos64421833san_t_o_s
satiations10312113satiations
satins64930483sa__ti_ns
scalations1239783scalations
scansions1145323scan_sions
scions82612243s__c_ions
section92515663s_ection_
sedations10311253sedations
seditions1039013seditions
seductions1366873seductions
selections12310873selections
sensations1059853sensations
sinuations1039413sinuations
solations9814623solations
solutions988883solutions
sonications1349953sonications
sorptions1137123sorptions
stagnations1244903stagnations
stanchion1444643stanchion_
stations82415223s_tations
stiction1038823stiction_
strictions1249143strictions
suction93713043s_uction_
sudations1039903sudations
sulcations1289583sulcations
taction93213023ta_ction_
tarnations1038903tarnations
taxations1636863taxations
tractions11511623tractions
unction9310663_unction_
vacations141910553vacations
venations12311723venations
wanions104011373wan__ions
wantons103713013wan_t_ons
zonations18139313zonations

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.420425454.8
2DLD Change Limit1486411396.34323433.9
3Display Results1391390.0632206.3
 (SQL Overall)1786911396.82626178.0
 
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.