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 “zacatons” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
zacatons194570(None) 
sacatons1038971sacatons
zacaton1845631zacaton_
sabatons1037842sabatons
sacaton938992sacaton_
vacations141910552vacations
abators94413083_abators
acajous1666483_acajous
acetins9313173_acetins
acetone9310793_acetone
acetones10310033_acetones
acetous9410363_acetous
actins86321103_ac_tins
actions94218513_actions
actors81016763_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
factors12912123fac_tors
gigatons1046053gigatons
halations12312393halations
jactations1936893jactations
lactations1239423lactations
lactone9311393lac_tone
lactones10311223lac_tones
lavations1238973lavations
laxations1637623laxations
locations112512743locations
locators102910433locators
macacos1338083macaco_s
macaroni1246523macaroni
macaronis1346563macaronis
macaroons1345563macaroons
macons104017243mac__ons
macrons113514893mac_rons
marathons1446413marathons
marcatos1249163marcato_s
megatons11279703megatons
natations91412493natations
negatons9299273negatons
pactions122613503pactions
paragons11311503paragons
partons94620513pa_rtons
placations1438583placations
rabatos93010903rabato_s
raccoons1265453raccoons
racons84319343rac__ons
racoons93912433rac_oons
rattons73815323ra_ttons
sabaton937713sabaton_
sabayons1343963sabayons
tachyons1644623tachyons
tactions102912423tactions
taxations1636863taxations
vacates12312833vacat_es
vacating14310353vacating
vacation131911893vacation_
vocations141911423vocations
wantons103713013wa_ntons
zabaione1942793zabaione
zabaiones2043003zabaiones
zabajone2642053zabajone
zabajones2742003zabajones
zapateos1943113zapateos
zeatins16311733z_eatins
zocalos1835393zocalo_s
zonations18139313zonations

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.420425454.8
2DLD Change Limit146162846.72021750.3
3Display Results84840.0302800.0
 (SQL Overall)178691847.17024922.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.