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

35 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
unencouraging17995(None) 
encouraging1552882__encouraging
decoupaging1851944_de_coupaging
discouraging1753124_discouraging
encouragingly2061344__encouragingly
overencouraging2271624overencouraging
bescouring1584645_bescour__ing
decorating14312075_de_co_rating
encaging1258735__enc___aging
encoring11312175__enco_r__ing
encourage1244155__encourag__e
encouraged1443095__encourag_ed
encourager1352775__encourag_er
encouragers1452355__encouragers
encourages1344045__encourag_es
engorging1244875__engo_r_ging
enraging1049575__en___raging
mercurating1645955_merc_urating
noncorroding1652335_noncorroding
scourging1334575___scour_ging
unanchoring1752185unanchor__ing
uncaging1268715u__nc___aging
uncharging1744395u__nchar_ging
unchurching2251675u__nchurching
uncoating12611925u__nco__ating
uncorking1637405u__nco_r_king
uncoupling1544465u__ncou_pling
uncrating12813185u__nc__rating
uncurbing1455515u__nc_ur_bing
uncurling1237115u__nc_ur_ling
undercharging2152595underchar_ging
undercoating1645375underco__ating
undercounting1763085undercou_nting
unendearing1343045unen__dearing
unnourishing1651155un_n_ourishing

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 Filter1786911247900.406440125.6
2DLD Change Limit124790358.72014310.8
3Display Results35350.0132692.3
 (SQL Overall)178691359.13919552.6
 
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.