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

73 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
masterlinesses1673521masterlinesses
masterliness1463832masterliness__
mannerlinesses1652403mannerlinesses
miserlinesses1554663mis_erlinesses
dastardlinesses1761834dastardlinesses
fatherlinesses2052614fatherlinesses
maidenlinesses1751974maidenlinesses
mannerliness1452564mannerliness__
masterfulnesses2053294masterfulnesses
miserliness1344914mis_erliness__
motherlinesses1962354motherlinesses
painterlinesses1792014painterlinesses
steelinesses1246724__steelinesses
waterinesses1567194wa_ter_inesses
austerenesses1354175auster_enesses
beastlinesses1563425beast__linesses
brotherlinesses2071245brotherlinesses
costlinesses1446255cost__linesses
dastardliness1561375dastardliness__
earlinesses11311045ea___rlinesses
earthlinesses1643915eart_hlinesses
easterlies1046715easterli_e_s__
elderlinesses1453265_elderlinesses
fatherliness1853325fatherliness__
ghastlinesses1742745ghast__linesses
gingerlinesses1652685gingerlinesses
hastinesses141210695hast___inesses
jitterinesses2083315jitter_inesses
lubberlinesses1851745lubberlinesses
maidenliness1552085maidenliness__
maltinesses13310235malt___inesses
manlinesses13910195ma___nlinesses
massinesses12128695mas___sinesses
masterfulness1853515masterfulness__
masteries111018495master_i_e_s__
masterminded1851345mastermin__ded
masterminds16102415mastermin_ds__
masterpiece1752045masterpi_e_ce_
masterpieces1851885masterpi_e_ces
mastersinger1561335mastersin__ger
mastersingers1671205mastersingers__
materialnesses1653915ma_terialnesses
mateynesses1645175ma_te__ynesses
matinesses12314545ma_t___inesses
mealinesses13310975m___ealinesses
merrinesses1358265m___errinesses
mistinesses131310625mist___inesses
motherliness1753085motherliness__
mustinesses131010415must___inesses
nastinesses111110745nast___inesses
orderlinesses1453395_orderlinesses
painterliness1572435painterliness__
paltrinesses1445515palt_r_inesses
paperinesses1646055pa_per_inesses
pastinesses13911715past___inesses
pastoralnesses1653135pastoralnesses
seemlinesses1445225__seemlinesses
statelinesses1344235state_linesses
steadinesses1346905__steadinesses
steaminesses1446225__steaminesses
steeliness1046795__steeliness__
sterlingnesses1553145__sterlingnesses
sternnesses1146635__ster_nnesses
storminesses1445035__storminesses
sturdinesses1345795__sturdinesses
surlinesses11310055__s_urlinesses
tastefulnesses1754605tastefulnesses
tastinesses111110785tast___inesses
unseemlinesses1652285unseemlinesses
unsteadinesses1553065unsteadinesses
wastefulnesses2054525wastefulnesses
wateriness1348075wa_ter_iness__
waterlines1348955wa_terline_s__

Search took 8 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 Limit95024736.98313607.9
3Display Results73730.0461587.0
 (SQL Overall)178691737.38924183.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.