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 “masterliness” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
masterliness146383(None) 
mannerliness1452562mannerliness
masterlinesses1673522masterlinesses
miserliness1344912mis_erliness
dastardliness1561373dastardliness
easterlies1046713easterli_e_s
fatherliness1853323fatherliness
maidenliness1552083maidenliness
masterfulness1853513masterfulness
masteries111018493master_i_e_s
masterminds16102413mastermin_ds
mastersingers1671203mastersingers
motherliness1753083motherliness
painterliness1572433painterliness
steeliness1046793__steeliness
wateriness1348073wa_ter_iness
waterlines1348953wa_terline_s
afterlifes1643184_afterlife_s
afterlives1643554_afterlive_s
austereness1154294auster_eness
baseliners1243864bas_e_liners
baselines1138604bas_e_line_s
beastliness1343334beast__liness
brotherliness1881864brotherliness
centerlines1346994centerline_s
costliness1245994cost__liness
datelines1088854da_te_line_s
earliness939694ea___rliness
earthliness14144144eart_hliness
easterners1044824easter__ners
elderliness1242854_elderliness
fosterlings1542854fosterlin_gs
ghastliness1542644ghast__liness
gingerliness1452794gingerliness
hastiness122410884hast___iness
interliners11138694_interliners
interlines101116454_interline_s
jitteriness1843274jitter_iness
lubberliness1671654lubberliness
lusterless1043694lusterl__ess
maltiness112910574malt___iness
manliness111310124ma___nliness
mannerless1243524mannerl__ess
mannerlinesses1652404mannerlinesses
marlines103818714ma___rline_s
masculines1445514mas_culine_s
massiness112810144mas___siness
mastering122315304master_in__g
mastermind1583954mastermin__d
masterminded1851344masterminded
masterpiece1752044masterpi_ece
masterpieces1851884masterpieces
mastersinger1561334mastersinger
mastless102610024mast__l__ess
mateless102711294ma_te_l__ess
materialness1454664ma_terialness
materiels1147834ma_ter_i_els
mateyness1444474ma_te__yness
matiness102114754ma_t___iness
mealiness11310064m___ealiness
merriness1138294m___erriness
miserlinesses1554664mis_erlinesses
mistiness111911634mist___iness
musteline1146974muste_line__
mustiness112211664must___iness
mysteries141211194myster_i_e_s
nastiness92310574nast___iness
orderliness1243064_orderliness
paltriness1244994palt_r_iness
paperiness1446134pa_per_iness
passerines1246164passer_ine_s
pastiness112312354past___iness
pastoralness1453604pastoralness
seemliness1244154__seemliness
slatternliness146884slatternliness
stateliness1144234state_liness
steadiness1146704__steadiness
steaminess1236774__steaminess
sterlingness1383384__sterlingness
sterlings10308754__sterlin_gs
sternness946094__ster_nness
storminess1245214__storminess
sturdiness1144844__sturdiness
surliness939944__s_urliness
tastefulness1554854tastefulness
tasteless935674taste_l__ess
tastiness92311144tast___iness
unmannerliness166984unmannerliness
unseemliness1452364unseemliness
unsteadiness1353064unsteadiness
vaselines1246714vas_e_line_s
wastefulness1854834wastefulness
wasteries121115344waster_i_e_s
waterless1238014wa_terl__ess
waterline1249654wa_terline__
westerlies1345614westerli_e_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 Filter1786911247900.390458182.1
2DLD Change Limit124790966.56319014.2
3Display Results96960.0601600.0
 (SQL Overall)178691967.01325480.0
 
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.