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

53 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
octangles124346(None) 
octangle1143831octangle_
entangles1075562entangles
octanes91111392octan__es
octanols1044552octanol_s
rectangles1344002rectangles
tangles83920042__tangles
untangles1054712untangles
angles74426703___angles
bangles103617413__bangles
candles104422343_c_andles
cangues10611823_c_angues
cantles94721413_c_antles
changes134517583_chang_es
comingles1444723comingles
crankles143510153_crankles
cringles11329463_cringles
dangles93618423__dangles
entangle966253entangle_
entangled1184513entangled
entangler1063963entangler
entanglers1163033entanglers
jangles154015683__jangles
mangles104021463__mangles
octagons1144493octa_gons
octane81411633octan__e_
octanol944743octanol__
octans81411143octan___s
octants9128733octan__ts
octaves12316963octa__ves
octuples1244133oct_uples
oranges84215333o_rang_es
otalgies936393o_talgies
outages82317323outa_g_es
outargues1044873outargues
outhandles1473653outhandles
outranges102510013outrang_es
oxtongues1741843oxtongues
pentangles1344833pentangles
rectangle1244263rectangle_
spangles1138893_spangles
strangles103011553strangles
tangle74019953__tangle_
tangled94214633__tangled
tangler83515073__tangler
tanglers92911973__tanglers
tingles83818323__tingles
triangles1035743triangles
twangles1245743_twangles
untangle966323untangle_
untangled1165123untangled
wangles113416933__wangles
wrangles1237463_wrangles

Search took 7 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 Filter1786911486410.403443402.0
2DLD Change Limit148641536.31323545.2
3Display Results53530.0331606.1
 (SQL Overall)178691536.74926476.7
 
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.