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

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
postmasterships2414182(None) 
postmastership23141921postmastership_
headmasterships26111184headmasterships
masterships1855374____masterships
postmasters15115324postmaster____s
commanderships2671925co_mmanderships
containerships2163055cont_ainerships
headmastership25101285headmastership_
mastership1755635____mastership_
pastorships1895895p____astorships
postmaster14115715postmaster_____
postmistress1661835postmistres___s
postmistresses1761215postmistres_ses
primateships2183015p_rima_te_ships
apostleships1961946apost___le_ships
commandership2572016co_mmandership_
consumerships2262886consum___erships
containership2063156cont_ainership_
controllerships22132026controllerships
copartnerships23132356co__partnerships
cosponsorships2372086cospons_orships
dictatorships2162496dict_a_torships
instructorships2271346instructorships
listenerships1861846list__enerships
mateships1646476____ma_te_ships
moderatorships2262086modera_torships
nonmemberships2571336no_nmemberships
outmastering1552956_outmaster__ing
outmasters1245736_outmaster____s
partnerships1953526part___nerships
pastorship17116096p____astorship_
poetasters1245286poet_aster____s
posthastes1546276posthaste_____s
postmastectomy2581136postmaste_ctomy
praetorships1954546p___raetorships
premierships2163166p_rem__ierships
primateship2062966p_rima_te_ship_
protectorships2362876prot_ectorships
senatorships1754356__sena_torships
speakerships2362826__spea_kerships
spectatorships2372276spect_a_torships
starships1447666__st_a___rships
toastmasters1452266toastmaster____s
trusteeships1761836___trusteeships

Search took 9 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 Limit95024447.61012486.7
3Display Results44440.0301466.7
 (SQL Overall)178691448.00022336.4
 
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.