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

42 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
nonmemberships257133(None) 
nonmembership2471411nonmembership_
memberships2253043___memberships
consumerships2262884consum_erships
membership2153004___membership_
nonmembers1643154nonmember____s
commanderships2671925commanderships
consumership2162965consum_ership_
containerships2163055containerships
nonmember1543125nonmember_____
premierships2163165__premierships
collectorships2362706collectorships
comembers1744226co_member____s
commandership2572016commandership_
comradeships2262236co_mrade_ships
containership2063146containership_
controllerships22132026controllerships
copartnerships23132356copartnerships
counselorships2172216counse_lorships
dealerships1753836___dealerships
donorships1655156don____orships
elderships1654456____elderships
followerships2461446fo_llowerships
foremanships2253736fo_rem_anships
governorships2262316go_vernorships
horsemanships2363056horsem_anships
landownerships239976landownerships
leaderships1794196___leaderships
listenerships1861846liste_nerships
managerships2062486man__agerships
masterships1855376___masterships
mentorships1855186___mentorships
monitorships1953896mon__itorships
noncelebrities1862166noncelebrities
ownerships1854096_o___wnerships
postmasterships24141826postmasterships
premiership2063286__premiership_
readerships1794656___readerships
receiverships2371716_receiverships
soldierships1862576so__ldierships
speakerships2362826__speakerships
viewerships2252696__vie_werships

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.1401276364.3
2DLD Change Limit124790429.56313049.3
3Display Results42420.0301400.0
 (SQL Overall)178691429.73318359.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.