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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

104 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
masseters113628(None) 
masseter1037061masseter_
assenters966992_assenters
asserters956392_asserters
marketers1545982marketers
massagers1245512massagers
masseteric1452342masseteric
masseurs1034922masse_urs
masters94628922ma_s_ters
missteers1135912missteers
absenters1156173_absenters
amassers10337843amass__ers
ammeters1237693_ammeters
assayers1144843_assayers
assenter867703_assenter_
assentors955653_assentors
asserter877573_asserter_
assertors965973_assertors
assetless943573_assetless
assets65617663_asset__s
assisters936353_assisters
assorters965733_assorters
assumers1064963_assumers
assurers866313_assurers
asters65631603_a_s_ters
basseted1136753bassete_d
bassets96414823basset__s
bassetts10407373basset_ts
basters94930303ba_s_ters
cassenes103611293cassene_s
cassettes1146703cassettes
casters94729903ca_s_ters
catheters1437013catheters
dabsters1137053dabs_ters
dasymeters1643593dasymeters
dissenters1197723dissenters
dissevers1386863dissevers
easters75125683ea_s_ters
fasteners12237053fasteners
gagsters10317083gags_ters
gamesters1236733gamesters
gasometers1346643gasometers
gassers84714633gass__ers
gasters85624293ga_s_ters
hamsters13710423hams_ters
hasteners12267813hasteners
lamsters1099753lams_ters
lassoers8338513lass_oers
lasters75627693la_s_ters
machetes1539633machete_s
magisters1235803magisters
maltsters1135193maltsters
manometers1448023manometers
marketeers1643123marketeers
marketer1437383marketer_
masers84623453ma_s__ers
mashers124621053ma_s_hers
maskers133913843ma_s_kers
masquers19195703ma_squers
massacrers1442283massacrers
massacres1344693massacres
massager1136873massager_
massages1159883massage_s
masses85028713mass__e_s
masseur935703masse_ur_
masseuses1144793masseuses
massier93615223mass_ier_
massiness112810143massiness
massless10277113mass_less
master84831343ma_s_ter_
mastery124214323ma_s_tery
maters85032393ma___ters
matters94421753ma__tters
meeters94714543m__eeters
meisters103313843meis_ters
messengers1342913messengers
meters85625833m___eters
minsters103813923mins_ters
misalters1136913misalters
misenters1139533misenters
misinters1138183misinters
misrefers1445363misrefers
missets94516573misset__s
missteer1037223missteer_
missteps12156143miss_teps
misters93927513m_is_ters
mobsters12359063mobs_ters
molesters1198873molesters
monsters103314553mons_ters
mossers94116193moss__ers
munsters104010553muns_ters
musketeers1642213musketeers
musters94522513m_us_ters
passengers1343213passengers
passers94717753pass__ers
passovers14144753passovers
pasters94531733pa_s_ters
rasters74629023ra_s_ters
tapsters10318803taps_ters
tassets75012773tasset__s
tasters74225643ta_s_ters
waisters113811523wais_ters
wasters104026593wa_s_ters
yawmeters1783873yawmeters

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411046.54622707.1
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.01525472.7
 
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.