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 “septentrion” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

36 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
septentrion139230(None) 
septentrions1472201septentrions
septentrional1581282septentrional
detention10169543de_tent_ion
retention91611483re_tent_ion
septenaries1375353septenaries
septenarii1252123septenari_i
septenarius1392733septenarius
abstention1254394abstent_ion
attention946104_attent_ion
centenarian1364684centenarian
contention12412224content_ion
depletion1256664deple_t_ion
detection121310414de_tect_ion
detentions11148804de_tent_ions
distention11158874distent_ion
extension1646294_exten_sion
intention9412014_intent_ion
repetition1278234repetit_ion
repletion1147694reple_t_ion
retentions101611114re_tent_ions
secretion11118304secre_t_ion
segmentation1556004segmentation
selection11311274se_lect_ion
sententia946654sentent_i_a
sententiae1056054sentent_iae
sentential1047534sentent_ial
sententious11104184sentent_ious
separation12510434separat_ion
septarian1146944sept__arian
septenary1443734septenar__y
septennial1253734septen_nial
septillion1263144sept_illion
stentorian1055224s__tentorian
subvention1574674subvent_ion
sustentation1255024sustentation

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819369.21616147.9
3Display Results36360.0162250.0
 (SQL Overall)178691369.65518507.6
 
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.