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

121 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
sacatons103897(None) 
sabatons1037841sabatons
sacaton938991sacaton_
zacatons1945701zacatons
sabaton937712sabaton_
sabayons1343962sabayons
vacations141910552vacations
zacaton1845632zacaton_
abators94413093_abators
acajous1666483_acajous
acetins9313173_acetins
acetone9310793_acetone
acetones10310033_acetones
acetous9410363_acetous
actins86321103_ac_tins
actions94218513_actions
actors81016773_ac_tors
alations82518893_alations
amatols938183_amatols
amazons1836653_amazons
bacons104917583bac__ons
barytons1345573barytons
batons85519423__batons
cacaos104616183caca_o_s
canons85522063__canons
cantons95221203ca_ntons
capons104119503__capons
cartons94122473ca_rtons
cations94524143__cations
cratons94316033_cratons
cytons111710183__cytons
dacrons103211033dac_rons
dalapons1145443dalapons
daltons8310403da_ltons
decagons1235893decagons
excitons1746043excitons
factions133013063factions
factors12912133fac_tors
gigatons1046053gigatons
halations12312393halations
jactations1936893jactations
lactations1239423lactations
lactone9311413lac_tone
lactones10311243lac_tones
lavations1238973lavations
laxations1637623laxations
locations112512743locations
locators102910433locators
macacos1338083macaco_s
macaroni1246523macaroni
macaronis1346563macaronis
macaroons1345563macaroons
macons104017243mac__ons
macrons113514893mac_rons
marathons1446423marathons
marcatos1249163marcato_s
megatons11279703megatons
natations91412493natations
negatons9299273negatons
pactions122613503pactions
paragons11311503paragons
partons94620513pa_rtons
placations1438583placations
rabatos93010903rabato_s
raccoons1265453raccoons
racons84319343rac__ons
racoons93912433rac_oons
rattons73815323ra_ttons
sabayon1244233sabayon_
sadirons936023sadirons
saffrons1444303saffrons
salmons93713263sa_lmons
salons63823693s__alons
saloons74415323sa_loons
saltations10310623saltations
salvations1338133salvations
sanctions1138873sanctions
santols73513323sa_ntols
santos64421833sa_nto_s
sapajous1744833sapajous
sarans64224433sara__ns
sartors7314973sa_rtors
saskatoons1441513saskatoons
satiations10312113satiations
satins64930483s__atins
savarins1139893savarins
savates10312953savat_es
scalations1239783scalations
scans74625103s_ca__ns
scathes124515713s_cathes
scats75930603s_cat__s
scatts85914663s_cat_ts
scions82612243s_c_ions
seasons72614233s_easons
sections102714703sections
sectors93116453sec_tors
sedations10311253sedations
senators8312953senators
setons64620173s__etons
sextons143710413s_extons
skatols1135533s_katols
solations9814623solations
solitons849593solitons
staccatos1343723staccato_s
statins73719773s_tatins
stations82415223s_tations
stators73915583s_tators
stratous8410703stratous
subatoms1245883subatoms
suctions103012903suctions
sudations1039903sudations
sulcations1289583sulcations
synanons1144633synanons
tachyons1644623tachyons
tactions102912423tactions
taxations1636863taxations
vacates12312833vacat_es
vacating14310363vacating
vacation131911893vacation_
vocations141911423vocations
wantons103713013wa_ntons

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621217.14020470.9
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.59223536.7
 
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.