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

138 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
masseter103706(None) 
masseters1136281masseters
assenter867702_assenter
asserter877572_asserter
basseted1136742basseted
marketer1437382marketer
massager1136872massager
masseteric1452342masseteric
masseur935702masse_ur
massier93615222mass_ier
master84831342ma_s_ter
missteer1037222missteer
absenter1086773_absenter
amasser9418733amass__er
ammeter1148393_ammeter
assayer1035573_assayer
assented957513_assented
assenters966993_assenters
assentor865293_assentor
asserted957903_asserted
asserters956393_asserters
assertor865723_assertor
asset55932263_asset__
assets65617663_asset_s
assister836753_assister
assorter866673_assorter
assumer965363_assumer
assurer767793_assurer
aster55434893_a_s_ter
basset85225383basset__
bassets96414823basset_s
bassett94213863basset_t
bassetted1244693bassetted
bassetts10407373bassetts
baster85333593ba_s_ter
casketed1534953casketed
cassene93111543cassene_
cassenes103611293cassenes
cassette1047813cassette
cassettes1146703cassettes
caster85232573ca_s_ter
catheter1338153catheter
cosseted1178343cosseted
dabster1036703dabs_ter
dasymeter1553503dasymeter
dissenter1059133dissenter
dissever12107653dissever
easter65027983ea_s_ter
fastener11227833fastener
faster94625773fa_s_ter
gagster9317633gags_ter
gamester1137323gamester
gasometer1267083gasometer
gasser75017773gass__er
gassier83812573gass_ier
gaster75027353ga_s_ter
gusseted1043553gusseted
hamster12810423hams_ter
hastener11259133hastener
lamster9109913lams_ter
lassoer7379383lass_oer
laster64830633la_s_ter
machete14310883machete_
machetes1539633machetes
magister1136283magister
maltster1035303maltster
manometer1368763manometer
marketed1537323marketed
marketeer1543593marketeer
marketers1545983marketers
marshier1337593marshier
maser75029973ma_s__er
masher114123203ma_s_her
masker124416103ma_s_ker
masquer18266463ma_squer
massacre1244743massacre
massacrer1342893massacrer
massage1039893massage_
massaged1236753massaged
massagers1245513massagers
massages1159883massages
masse75125293mass__e_
massed94421323mass__ed
massedly1444303massedly
masses85028713mass__es
masseurs1034923masseurs
masseuse1044253masseuse
masseuses1144793masseuses
massive12289773massive_
masted94025803ma_s_ted
mastered112614003mastered
masters94628923ma_s_ters
mastery124214323ma_s_tery
mater74438863ma___ter
matter84325343ma__tter
meeter83616503m__eeter
meister93114163meis_ter
messenger1243303messenger
messier93412923mess_ier
meter75130323m___eter
minster93914323mins_ter
misalter1038343misalter
misenter10310833misenter
misinter1038833misinter
misrefer1346103misrefer
misseated12610113misseated
misset85028153misset__
missets94516573misset_s
missteers1135913missteers
misstep11158463miss_tep
mister84728563m_is_ter
mobster11299213mobs_ter
modester1197483modester
moister94015373mois_ter
molester1099373molester
monster93214603mons_ter
mosser84618273moss__er
mossier94413813moss_ier
munster93710523muns_ter
musketeer1542553musketeer
mussier93314363muss_ier
muster84724523m_us_ter
passee84522023passe_e_
passenger1243413passenger
passer84721033pass__er
passover13135533passover
paster85734373pa_s_ter
raster64731443ra_s_ter
sassier73413233sass_ier
tapster9299273taps_ter
tasseled935593tasseled
tasset65925313tasset__
tassets75012773tasset_s
taster64930573ta_s_ter
vaster94521023va_s_ter
waister103812383wais_ter
waster95228943wa_s_ter
yawmeter1693873yawmeter

Search took 7 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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621386.67321903.5
3Display Results1381380.0463000.0
 (SQL Overall)1786911386.88925938.6
 
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.