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

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

38 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
permanentnesses1961301permanentnesses
permanentness1761742permanentness__
perfectnesses2053355per__fectnesses
permanences1754505permanen_ce_s__
permanencies1853565permanencie_s__
permanents1455465permanent___s__
presentnesses1554425p_r_esentnesses
apparentnesses18121776_apparentnesses
brazennesses2343286_br_azen_nesses
cravennesses1744116_cr_aven_nesses
currentnesses1552996cur__rentnesses
demandingnesses2061746de_mandingnesses
earnestnesses1353666_e_arnestnesses
erectnesses1347476_er___ectnesses
femalenesses1746866fe_male__nesses
femininenesses1952996fe_mininenesses
frequentnesses2661426_frequentnesses
humanenesses1744256_humane__nesses
leadennesses1354576le__aden_nesses
peakednesses1945046pe__ake_dnesses
peartnesses1338746pe__a__rtnesses
perfectness1853506per__fectness__
permanence1654866permane__n__ce_
permanent1368786permane__n____t
permanently1873856permanent____ly
pertnesses12310316per_____tnesses
pervasivenesses2355206pervasivenesses
piquantnesses2452036piqua__ntnesses
planenesses1349036p__lane__nesses
pleasantnesses1661566p_leasantnesses
pliantnesses1444466p_lia__ntnesses
prematurenesses1971956prematurenesses
preparednesses1963096prepare_dnesses
presentness1345666p_r_esentness__
profanenesses1853486profane__nesses
pronenesses1379266p_r_one__nesses
recentnesses1465376__r_ecentnesses
serenenesses12117116ser___enenesses

Search took 9 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 Limit95024387.70312336.0
3Display Results38380.0331151.5
 (SQL Overall)178691388.09622071.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.