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

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
perfectnesses205335(None) 
erectnesses1347472_er_ectnesses
imperfectnesses2461532imperfectnesses
perfectness1853502perfectne_s_s
correctnesses1754213correctnesses
directnesses1595283dir_ectnesses
pertnesses12310313per___tnesses
presentnesses1554423presentnesses
selectnesses1446113se_lectnesses
abjectnesses2352564_abjectnesses
currentnesses1552994currentnesses
deftnesses1436814de_f__tnesses
directresses15123084dir_ectresses
earnestnesses1353664earnestnesses
effetenesses1854524_effetenesses
electresses1345964_e_lectresses
erectness1146124_er_ectne_s_s
exactnesses2044344_e_xactnesses
expertnesses2144844_expertnesses
greatnesses1247794_gr_eatnesses
imperfectness2261704imperfectne_s_s
meetnesses1237454me__e_tnesses
peakednesses1945044peake_dnesses
peartnesses1338744pe__artnesses
pepperinesses1653274pepperinesses
perfecters1745434perfect_e__rs
perfectest1744814perfect_e_s_t
perfectiveness2455344perfectiveness
perfectives2145474perfect__ives
perkinesses1748924per__kinesses
permanentnesses1961304permanentnesses
perversenesses1952664perversenesses
pervertednesses2162764pervertednesses
precesses13310464p_r_ec__esses
prestresses1346724p_r_estresses
prettinesses1447544p_r_ettinesses
priestesses13104274p_riest_esses
promptnesses1843634p_romptnesses
protectresses1762364protectresses
purenesses12810744pur_e__nesses
recentnesses1465374re_centnesses
serenenesses12117114ser_enenesses
strictnesses1445414str_ictnesses
tersenesses1149044terse__nesses

Search took 7 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 Limit95024445.71616624.2
3Display Results44440.050880.0
 (SQL Overall)178691446.12629169.3
 
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.