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

65 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
octagons114449(None) 
octagon1045241octagon_
octagonal1242642octagonal
octanols1044552octanols
octans81411142octa__ns
octavos12134482octavo_s
actinons10389453actinons
actions94218513act_ions
agons66423783___agons
canons85522063_c_anons
capons104119503_c_apons
cations94524143_cations
claxons1635803_claxons
cogons96818113_c_ogons
contagions1346603contagions
cotans81317923cota__ns
cottons9312193cot_tons
cratons94316033_cratons
crayons12439233_crayons
decagons1235893decagons
dragons938383_dragons
estragons1044653estragons
etalons739073_etalons
flagons1137973_flagons
heptagons1543453heptagons
hexagons1943943hexagons
locations112512743locations
martagons1245123martagons
mutagens1144853mutagens
nonagons947223nonagons
obtains939163obta_ins
occasions1344063occasions
oceans81211003ocea__ns
octads987333octa__ds
octan71313483octa__n_
octane81411633octa__ne
octanes91111393octa_nes
octangles1243463octangles
octanol944743octano_l
octant81216553octa__nt
octants9128733octa_nts
octaves12316963octa_ves
octavo11124783octavo__
octopods1344343octopods
octoroons1143423octoroons
octrois938343oct_rois
options93810603opt_ions
orations81515803orations
organons945583organons
outages82317323outag_es
outgains9810163outgains
outgoes8312643out_goes
outgone8311463out_gone
outguns8318693out_guns
ovations11149263ovations
paragons11311513paragons
pentagons1246153pentagons
talons64019443__talons
tauons63412673__tauons
taxons134211503__taxons
tetragons1045353tetragons
tigons74112263__tigons
vocations141911423vocations
wagons103911213__wagons
yatagans1244083yatagans

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.436409841.7
2DLD Change Limit146162657.31319986.6
3Display Results65650.0302166.7
 (SQL Overall)178691657.77922970.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.