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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

109 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
batons8551942(None) 
bacons104917581bacons
barons85025381barons
baton75822421baton_
betons84919551betons
abators94413082abators
aeons57624652_aeons
agons66423782_agons
atoms76817562_atoms
atone56527982_atone
atones65225772_atones
atony87218852_atony
axons125517932_axons
azons146518252_azons
baboons113211072baboons
baboos103517012baboos
bacon95620592bacon_
bairns86710872bairns
ballons93916962ballons
banns75321232ba_nns
bans66555142ba__ns
barns76335142ba_rns
baron78131242baron_
barong96015822barong
barongs105310832barongs
barony115915302barony
baryons121010472baryons
barytons1345572barytons
basins85722762basins
basions94213952basions
bastions10411692bastions
batboys1465832batboys
bates75846342bat_es
bathes116524832bathes
bathos116215632bathos
baths105922922bat_hs
batiks1239372batiks
bating95132252bating
bats66962332bat__s
battens95313262battens
batts76727562bat_ts
bayous11411152bayous
bazoos173212622bazoos
beacons11410732beacons
belons84119412belons
beton76022062beton_
betony114211582betony
bisons83914372bisons
blazons1836162blazons
boons75031912b_oons
borons85520542borons
bosons85016652bosons
bostons9312902bostons
boutons9310782boutons
burtons9310852burtons
buttons9310332buttons
canons85522062canons
cantons95221202cantons
capons104119502capons
cartons94122472cartons
cations94524142cations
cratons94316032cratons
cytons111710182cytons
daltons8310402daltons
datos65222782dato_s
fanons96115212fanons
futons93911512futons
gators74115832gators
halons95720712halons
jatos125116822jato_s
jetons134512612jetons
kaons95014852ka_ons
kations114013662kations
latens64620212latens
macons104017242macons
masons83916512masons
matins84527782matins
matrons93517632matrons
mutons84314362mutons
nations74720562nations
natrons73215662natrons
nitons64614902nitons
paeons83915522paeons
partons94620512partons
patens84820862patens
patins87528782patins
patois84319362patois
patrons93818102patrons
pitons85319042pitons
putons83515152putons
racons84319342racons
radons74118532radons
ratans63819372ratans
rations74123432rations
ratoons73815472ratoons
ratos55528762rato_s
rattons73815322rattons
rayons94113342rayons
sabatons1037842sabatons
salons63823692salons
satins64930482satins
setons64620172setons
talons64019432talons
tauons63412672tauons
taxons134211502taxons
tons46553052__tons
wagons103911212wagons
wantons103713012wantons
yapons114411772yapons

Search took 3 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 Filter178691825510.1261418182.5
2DLD Change Limit825511092.67030918.0
3Display Results1091090.0333303.0
 (SQL Overall)1786911092.82963164.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.