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

32 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
sanguineness135243(None) 
sanguinenesses1562252sanguinenesses
genuineness1253843gen_uineness
languidness1342323langui_dness
sanguineous1251763sanguine_ous
sanguines1047183sangui__ne_s
agileness1046494_a_g_ileness
angriness1036454_angri__ness
angrinesses1247284_angrinesses
languidnesses1552404languidnesses
manginess122010414mang_i__ness
manginesses1499594mang_inesses
ongoingness1373044_ongoingness
ranginess101610214rang_i__ness
ranginesses121210114rang_inesses
sageness92111984sa_g___eness
sandiness102111714san_di__ness
sandinesses12911394san_dinesses
saneness82313724sa____neness
sanguinarias1362254sanguinarias
sanguine947634sangui__ne__
sanguinely1452234sangui__nely
sanguinities1353764sanguinities
singleness1145734sing__leness
slanginess1146274slang_i__ness
slanginesses1346964slang_inesses
snideness1067684s_n__ideness
supineness1245874s__upineness
tangibleness1553704tangibleness
tanginess10239284tang_i__ness
tanginesses1278884tang_inesses
vagueness1343934va_gu__eness

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 Filter1786911247900.390458182.1
2DLD Change Limit124790326.95617939.9
3Display Results32320.0132461.5
 (SQL Overall)178691327.35924282.0
 
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.