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

129 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
bayonet12121221(None) 
baronet91022201baronet
bayonets13135581bayonets
ballonet10314502ballonet
baloney1237482baloney
bannet84925332ba_nnet
baronets101410902baronets
basinet9318932basinet
bayoneted1542772bayoneted
jaconet16311482jaconet
abalone938903abalone_
abalones1038753abalones
agone65924553_agone_
agones75719863_agones
alone55732963_alone_
anyone94612733anyone_
atone56527983_atone_
atoned75417543_atoned
atoner64817193_atoner
atones65225773_atones
avocet11412683_avocet
avoset9315673_avoset
axone125918473_axone_
axones134614513_axones
backset15314193backset
bacon95620593bacon__
bacons104917583bacon_s
baguet9316103ba_guet
ballet84733973ba_llet
ballonets1146723ballonets
baloneys1334663baloneys
bane65250433ba__ne_
baned85436353ba__ned
banes74945583ba__nes
banned94721343ba_nned
banner84421503ba_nner
bannets94013843ba_nnets
banquet1839783banquet
barbet104427883ba_rbet
barned95623583ba_rned
barney115314453ba_rney
baron78131243baron__
baroness101210063baroness
baronetcy1642543baronetcy
barong96015823baron_g
barongs105310833barongs
baronies10315023baronies
baronne938263baronne
baronnes1038553baronnes
barons85025383baron_s
barony115915303baron_y
barret84930483ba_rret
baryon111211613baryon__
baryonic1546203baryonic
baryons121010473baryon_s
barytone1356023barytone_
barytones1455563barytones
basined10310003basined
basinets1039063basinets
basket125722913ba_sket
basset85225383ba_sset
bassinet10312843bassinet
baton75822423baton__
batons85519423baton_s
bayed115423023bay__ed
baying125222583bayin_g
baymen134212003bay_men
bayoneting1642303bayoneting
bayonetted1652003bayonetted
bayou10512363bayo__u
bayous11411153bayo_us
beaconed1336983beaconed
begone9512133begone_
beignet101510963beignet
bennet84823363b_ennet
beyond1237073beyon_d
beyonds1335063beyonds
biont7727163b_ion_t
bizone1738603bizone_
bizones1837823bizones
blazoned2044313blazoned
blazoner1944133blazoner
boloney1247763boloney
bone65949323b__one_
boned85133243b__oned
boner75133083b__oner
bones76446533b__ones
boney105227313b__oney
bonnet85524633b_onnet
botonee9311833botonee
brunet84419293b_runet
bryonies1336843bryonies
bryony1435833bryon_y
burgonet1148103burgonet
burnet84326173b_urnet
buyout11310103buyo_ut
bygone1256173bygone_
bygones1335913bygones
cabinet11318903cabinet
cajones163311333cajones
canzonet19410583canzonet
carnet84732873ca_rnet
coronet94227173coronet
crayoned1435003crayoned
crayoner1344863crayoner
cygnet1237893_cygnet
dragonet10138953dragonet
falconet13410363falconet
gannet74321853ga_nnet
garnet73928413ga_rnet
hairnet10911703hairnet
jaconets1745613jaconets
kayoed14416903kayo_ed
kayoes134710823kayo_es
layout9513703layo_ut
layover1334433layover
magnet9320663ma_gnet
masoned1039803masoned
nonet54540843__nonet
payment14310703payment
payout11714653payo_ut
rayon83815703rayon__
rayons94113343rayon_s
sarsnet7314813sarsnet
satinet7325283satinet
taboret92916113taboret
taloned8310223taloned
wagoned1256223wagoned
wagoner1136093wagoner

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271297.17318684.9
3Display Results1291290.0462804.3
 (SQL Overall)1786911297.62223444.1
 
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.