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

46 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
limpidness154308(None) 
liminess10510642lim_i_ness
limpidnesses1743622limpidnesses
limpness1246702limp__ness
lippiness1335412lippi_ness
liquidness2042512liquidness
lividness1344712li_vidness
lumpiness1336482lumpi_ness
timidness1244622tim_idness
wimpiness1635292wimpi_ness
blimpishness2172073blimpishness
bumpiness1535283bumpi_ness
campiness1537543campi_ness
dippiness1435973dippi_ness
dumpiness1435653dumpi_ness
flimsiness1543453flimsi_ness
hippieness1743253hippieness
hippiness1635463hippi_ness
humidness1544023hum_idness
humpiness1635773humpi_ness
impishness1744123_impishness
jumpiness2034293jumpi_ness
licitness1145373li_citness
limberness1443273limberness
limitedness1453893limitedness
limitless1142943lim_itless
lipides103810623li_pid_e_s
loopiness11136543loopi_ness
lucidness1244313l_ucidness
lumpishness1843153lumpishness
luridness1045193l_uridness
nippiness1334713nippi_ness
pipiness1238003pi_pi_ness
rapidness12155473_rapidness
rigidness1145123ri_gidness
riminess10510093rim_i_ness
simpleness1445173simpleness
skimpiness1842863skimpi_ness
sliminess1137423slim_i_ness
stupidness1343033stupidness
tepidness1244343_tepidness
tumidness1243843tum_idness
vapidness15144423_vapidness
vividness1643933vi_vidness
wimpishness2143213wimpishness
wispiness1435633wispi_ness

Search took 6 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 Filter1786911406030.423422437.4
2DLD Change Limit140603465.37326168.4
3Display Results46460.0331393.9
 (SQL Overall)178691465.82930655.5
 
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.