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 “punctuality” 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
punctuality185296(None) 
punctually1773362punctual_ly
unpunctuality2071202unpunctuality
actuality1445803__actuality
factuality1843863_factuality
mutuality1444743mu__tuality
punctual1243903punctual___
punctualities1753463punctualities
punctuate1343743punctua__te
punctuating1643103punctuating
punctuation1543483punctuation
centrality1547744cen_trality
conceptuality2264474conceptuality
dentality1348474den_t_ality
ductility1544844du_ct_ility
effectuality2382314effectuality
eventuality1753324eventuality
functionality2163534functionality
inequality2254574_inequality
mentality1449134men_t_ality
municipality2182114municipality
natality1139194__nat_ality
nuptiality1553684nu_ptiality
pansexuality2462704pansexuality
partiality1546784p_artiality
penality13310714pen___ality
practicality2153594practicality
principality2162664principality
punctate1246474punct_a__te
punctation1486054punct_ation
punctilio1352274punct_ili_o
punctilios1452284punct_ilios
punctuated1543374punctua_ted
punctuates1443454punctua_tes
punctuations1643184punctuations
punctuator1452324punctua_tor
punctuators1552224punctuators
puncturing1543304punctu_ring
sensuality1344434sen_suality
spirituality1763194spirituality
unclarity1445364_unc_larity
unmorality1554324_unmorality
unreality1246324_un_reality
virtuality1644294_virtuality

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819448.61017284.4
3Display Results44440.0301466.7
 (SQL Overall)178691449.06319716.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.