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

119 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
jaconet1631148(None) 
jaconets1745611jaconets
baronet91022202baronet
bayonet121212212bayonet
falconet13410352falconet
jacket194720672jac_ket
accent105116263_accent
acne66625873_ac_ne_
acned87520663_ac_ned
acnes75922623_ac_nes
aconite9315473_aconite
acorned10238263_acorned
agone65924553_agone_
agones75719863_agones
alone55732963_alone_
ancone83916953ancone_
ancones93116343ancones
atone56527983_atone_
atoned75417543_atoned
atoner64817193_atoner
atones65225773_atones
avocet11412683_avocet
avoset9315673_avoset
axone125918473_axone_
axones134614513_axones
backset15314193backset
bacon95620593bacon__
bacons104917583bacon_s
ballonet10314503ballonet
baloney1237483baloney
bannet84925333ba_nnet
baronets101410903baronets
basinet9318933basinet
bayonets13135583bayonets
beaconed1336983beaconed
cabinet11318903cabinet
cachet134526413cac_het
caconym1644953caconym
cajones163311333cajones
canzonet19410583canzonet
carcanet12316343carcanet
carnet84732873ca_rnet
coconut11511473coconut
comet95946073__comet
cone67256963__cone_
coned86040053__coned
cones76457423__cones
coney105932883__coney
conte76633203__conte
cornet84436733__cornet
coronet94227173coronet
coset75748843__coset
covet105638943__covet
dacoit9415453daco_it
deaconed1237493deaconed
dragonet10138953dragonet
facet106038523fac__et
falconer1346033falconer
falconets1444813falconets
gannet74321853ga_nnet
garnet73928413ga_rnet
hackney1935123hackney
hairnet10911703hairnet
icones84616383_icones
jabot14321513jabo__t
jacales16310323jacales
jacana1537933jacan_a
jacanas1638263jacanas
jacinth1954603jacinth
jacked204817523jac_ked
jacker194417583jac_ker
jackets205011373jac_kets
jackies202912623jackies
jackleg2135033jackleg
jackpot2245013jackpot
jacobin1844393jacobin
jacobus1843173jacobus
jane115031473ja__ne_
janes124928123ja__nes
jargoned1735233jargoned
jargonel1643683jargonel
jaunt125025273ja_un_t
jawbone19134443jawbone_
jawboned21133553jawboned
jawboner20133363jawboner
jawbones20134853jawbones
jennet134714953j_ennet
jocose1537103jocose_
jones125028183j__ones
laconic1139883laconic
lactone9311393lactone_
lactones10311223lactones
lacune8169673lacune_
lacunes9159623lacunes
macon94519953macon__
macons104017243macon_s
magnet9320663ma_gnet
masoned1039803masoned
nonet54540843__nonet
packet144726503pac_ket
rachet115028973rac_het
racket125229423rac_ket
racon75422143racon__
racons84319343racon_s
racquet1838743racquet
sachet114725773sac_het
sarcenet10413313sarcenet
sarsnet7314813sarsnet
satinet7325283satinet
scone74621833_scone_
scones84521303_scones
taboret92916113taboret
tacet75840023tac__et
tacket124627493tac_ket
taconite1049313taconite
taloned8310223taloned
vacant11415133vacan_t
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.1701051123.5
2DLD Change Limit1340271197.09318895.7
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.30924448.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.