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 “wholesomenessesa” 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
wholesomenesses2361911wholesomenesses_
wholesomeness2162403wholesomene_s_s_
lonesomenesses1653794_lonesomenesses_
awesomenesses1853385__awesomenesses_
fulsomenesses1853125_ful_somenesses_
gamesomenesses1962725_gamesomenesses_
gruesomenesses1753075_gruesomenesses_
handsomenesses2062705_handsomenesses_
longsomenesses1763085_longsomenesses_
noisomenesses1554245_no_isomenesses_
tiresomenesses1653345_tiresomenesses_
toilsomenesses1662705_toilsomenesses_
toothsomenesses2061905toothsomenesses_
wearisomenesses2062415wearisomenesses_
welcomenesses2052585w_el_comenesses_
wholenesses1745805whol____enesses_
winsomenesses1854045w__insomenesses_
worrisomenesses2062275worrisomenesses_
cohesivenesses2256206_cohesivenesses_
fearsomenesses1953196_fearsomenesses_
footsorenesses1792226_footsorenesses_
gladsomenesses1892386_gladsomenesses_
grotesquenesses2561516grotesquenesses_
hoarsenesses1545606_hoars__enesses_
hollownesses1852286_hol_lo_wnesses_
homesicknesses2561596_homesicknesses_
irksomenesses1953196__irksomenesses_
lightsomenesses2161826lightsomenesses_
lissomenesses1453476__lissomenesses_
loathsomenesses20112116loathsomenesses_
lonesomeness1454116_lonesomene_s_s_
obesenesses1346766__obes__enesses_
operosenesses1575326__operosenesses_
selfsamenesses1892146_selfsamenesses_
solemnnesses1443636_sole__mnnesses_
wholesomest1952916wholesom_____est
witlessnesses1547236witles__snesses_
woebegonenesses216876woebegonenesses_

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.310576422.6
2DLD Change Limit65874384.53314532.1
3Display Results38380.0301266.7
 (SQL Overall)178691384.87336669.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.