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

87 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
mastersingers167120(None) 
mastersinger1561331mastersinger_
masterliness1463833masterlin_ess
astringes1038334_ast_r_inge_s
butterfingers1961034butterfingers
costermongers1871184costermongers
easterners1044824easter__n_ers
masteries111018494master_i__e_s
mastering122315304master_ing___
masterminded1851344masterminde_d
masterminds16102414mastermin__ds
masterpieces1851884masterpiece_s
minnesingers1561034minne_singers
stringers104210644__st_r_ingers
supersingers1584344_supersingers
aspersers11377245_aspers___ers
aspersing1237605_aspersing___
assigners1044415_as___signers
asteriskless1651235_asteriskless
astringe938225_ast_r_inge__
astringed1145695_ast_r_inge_d
astringent1145905_ast_r_ingent
astringents1253915_ast_r_ingents
astrologers1252975_ast_rologers
baseliners1243865bas_e_lin_ers
costermonger1761375costermonger_
deringers1137185___der_ingers
derringers1243845___derringers
determiners1444645_determin_ers
distrainers1255055dist_rain_ers
easterlies1046715easterli__e_s
easterner945055easter__n_er_
estrangers11376105_est_r_angers
fasteners12237055faste___n_ers
fastenings14273905faste_ning__s
fosterlings1542855fosterling__s
handwringers2051375handwr_ingers
harbingers1643945ha___rbingers
hasteners12267815haste___n_ers
interliners11138695_interlin_ers
malingers1285855ma____lingers
mannerliness1452565mannerlin_ess
mariners103113865ma___r_in_ers
martensites1353625martensi_te_s
massagers1245515mas___s_agers
massiness112810145mas___sin_ess
masterfulness1853515masterfulness
masterlinesses1673525masterlinesses
mastermind1583955mastermin___d
masterminding1961165masterminding
masterpiece1752045masterpi__ece
masterships1855375masters__hips
masterstrokes1961185masterstrokes
materiels1147835ma_ter_i__els
maternities1346015ma_ternitie_s
mattering122314055matter_ing___
mesmerizers2452655mesmer_i_zers
messengers1342915m___essengers
minnesinger1451095minne_singer_
miserliness1344915mis_erlin_ess
misterming1538605misterming___
mustering122212335muster_ing___
mysteries141211195myster_i__e_s
oysterings1443905oyster_ing__s
paperhangers2051485pa_perhangers
passengers1343215pas___sengers
passerines1246165passer_in_e_s
pasteurizers2351765pasteuri_zers
patternings1443185patterning__s
plasterings1444745plaster_ing__s
restrainers1145125rest_rain_ers
smatterings14103845smatter_ing__s
springers12309985__s_pr_ingers
stepsisters1352135__stepsisters
sterlingness1383385__sterlingness
sterlings10308755__sterling__s
stingers94012745__st___ingers
strainers9510385__st_rain_ers
strangers104112165__st_r_angers
stringer93812945__st_r_inger_
supersinger1475145_supersinger_
wasteries121115345waster_i__e_s
wateriness1348075wa_ter_in_ess
waterings13229255wa_ter_ing__s
waterlines1348955wa_terlin_e_s
watersides1445535wa_tersi_de_s
westerners1344475wester__n_ers

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.406440125.6
2DLD Change Limit124790878.92013989.9
3Display Results87870.0631381.0
 (SQL Overall)178691879.38919032.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.