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

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

33 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
permanentnesses196130(None) 
permanentness1761742permanentne_s_s
perfectnesses2053354per__fectnesses
presentnesses1554424p_r_esentnesses
apparentnesses18121775_apparentnesses
brazennesses2343285_br_azen_nesses
cravennesses1744115_cr_aven_nesses
currentnesses1552995cur__rentnesses
demandingnesses2061745de_mandingnesses
earnestnesses1353665_e_arnestnesses
erectnesses1347475_er___ectnesses
femalenesses1746865fe_male__nesses
femininenesses1952995fe_mininenesses
frequentnesses2661425_frequentnesses
humanenesses1744255_humane__nesses
leadennesses1354575le__aden_nesses
peakednesses1945045pe__ake_dnesses
peartnesses1338745pe__a__rtnesses
permanences1754495permane__n__ces
permanencies1853565permane__n_cies
permanents1455455permanent_____s
pertnesses12310315per_____tnesses
pervasivenesses2355205pervasivenesses
piquantnesses2452035piqua__ntnesses
planenesses1349035p__lane__nesses
pleasantnesses1661565p_leasantnesses
pliantnesses1444455p_lia__ntnesses
prematurenesses1971955prematurenesses
preparednesses1963095prepare_dnesses
profanenesses1853485profane__nesses
pronenesses1379265p_r_one__nesses
recentnesses1465375__r_ecentnesses
serenenesses12117115ser___enenesses

Search took 5 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 Filter178691658740.313570897.8
2DLD Change Limit65874334.33015213.4
3Display Results33330.0301100.0
 (SQL Overall)178691334.67338239.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.