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

97 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
jaconets174561(None) 
jaconet16311481jaconet_
baronets101410902baronets
bayonets13135582bayonets
falconets1444812falconets
jackets205011372jac_kets
accents113511233_accents
acnes75922623_ac_ne_s
aconite9315473_aconite
aconites10314353_aconites
agones75719863_agone_s
ancones93116343ancone_s
atoners75013953_atoners
atones65225773_atone_s
avocets1235453_avocets
avosets1036663_avosets
axones134614513_axone_s
backsets1638853backsets
bacons104917583bacon__s
ballonets1146723ballonets
baloneys1334663baloneys
bannets94013843ba_nnets
baroness101210063baroness
baronet91022203baronet_
basinets1039063basinets
bayonet121212213bayonet_
cabinets1238283cabinets
cachets145014263cac_hets
caconyms1744003caconyms
cajones163311333cajone_s
canoness1039393canoness
canzonets2044483canzonets
carcanets1347313carcanets
carnets93918403ca_rnets
coconuts1246333coconuts
comets105823583__comets
cones76457423__cone_s
coneys115218423__coneys
contes84432913__contes
cornets94820573__cornets
coronets103814363coronets
cosets85824403__cosets
covets114819643__covets
dacoits1079073daco_its
deaconess1245543deaconess
dragonets11134503dragonets
facets116316653fac__ets
falconers1445323falconers
falconet13410353falconet_
gannets83811443ga_nnets
garnets84115403ga_rnets
hackneys2033683hackneys
hairnets1195633hairnets
icones84616383_icone_s
jabots1538883jabo__ts
jacales16310323jacale_s
jacanas1638263jacan_as
jacinth1954603jacin_th
jacinths2042733jacinths
jackers204214453jac_kers
jacket194720673jac_ket_
jackies202912623jackie_s
jacklegs2233963jacklegs
jackpots2344003jackpots
jacobins1944193jacobins
jacobus1843173jaco_bus
janes124928123ja__ne_s
jargonels1743153jargonels
jaunts137511883ja_un_ts
jawboners21133053jawboners
jawbones20134853jawbone_s
jennets14517633j_ennets
jones125028183j__one_s
laciness102112553laciness
lactones10311223lactone_s
lacunes9159623lacune_s
macons104017243macon__s
magnets10311143ma_gnets
nonets64118703__nonets
packets155114773pac_kets
packness1636933packness
rachets124516833rac_hets
raciness102413453raciness
rackets134916873rac_kets
racons84319343racon__s
racquets1944763racquets
sachets123914103sac_hets
sarcenets1146953sarcenets
sarsnets836783sarsnets
satinets8311733satinets
scones84521303_scone_s
solonets838233solonets
taborets10278063taborets
tackets134914363tac_kets
taconite1049313taconite
taconites1148473taconites
wagoners1235473wagoners

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 Limit146162977.50019488.3
3Display Results97970.0462108.7
 (SQL Overall)178691977.95222471.2
 
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.