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

44 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
limpidnesses174362(None) 
liminesses121310852lim_i_nesses
limpidness1543082limpidne_s_s
limpnesses14116652limp__nesses
lippinesses1535512lippi_nesses
liquidnesses2243082liquidnesses
lividnesses1545022li_vidnesses
lumpinesses15107112lumpi_nesses
timidnesses1445142tim_idnesses
wimpinesses1835632wimpi_nesses
blimpishnesses2382143blimpishnesses
bumpinesses17126373bumpi_nesses
campinesses1737113campi_nesses
dippinesses1635243dippi_nesses
dumpinesses16126253dumpi_nesses
flimsinesses1743993flimsi_nesses
hippienesses1943443hippienesses
hippinesses1845493hippi_nesses
humidnesses1744583hum_idnesses
humpinesses18106243humpi_nesses
impishnesses1944293_impishnesses
jumpinesses22125343jumpi_nesses
licitnesses1346413li_citnesses
limbernesses1643153limbernesses
limitednesses1654013limitednesses
loopinesses13116733loopi_nesses
lucidnesses1445243l_ucidnesses
lumpishnesses2043473lumpishnesses
luridnesses1246723l_uridnesses
nippinesses1545063nippi_nesses
pipinesses1448603pi_pi_nesses
rapidnesses1476473_rapidnesses
rigidnesses1345923ri_gidnesses
riminesses121211413rim_i_nesses
simplenesses1645623simplenesses
skimpinesses2043183skimpi_nesses
sliminesses1338093slim_i_nesses
stupidnesses1543353stupidnesses
tepidnesses1445383_tepidnesses
tumidnesses1444613tum_idnesses
vapidnesses1774893_vapidnesses
vividnesses1844223vi_vidnesses
wimpishnesses2343583wimpishnesses
wispinesses1636273wispi_nesses

Search took 4 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 Filter178691950240.360496363.9
2DLD Change Limit95024443.17329947.7
3Display Results44440.0301466.7
 (SQL Overall)178691443.56350151.8
 
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.