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

285 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
mastering12231531(None) 
mattering122314061mattering
mustering122212331mustering
altering91917122_altering
bantering122414242bantering
bartering122313652bartering
battering122715152battering
cantering122417382cantering
catering112019912ca_tering
faltering132211122faltering
fastening13268602fastening
festering132413172festering
fostering132411262fostering
gartering112111592gartering
haltering132212012haltering
hastening13259482hastening
kashering1736252kashering
lustering102711202lustering
mammering1337332mammering
martyring1535782martyring
masteries111018512masteries
mastermind1583952mastermind
masting104325822mast__ing
maturing1139962ma_turing
metering112915632m_etering
misterming1538602misterming
mitering113015402m_itering
muttering122611322muttering
nattering102212222nattering
oystering1337562oystering
paltering122612902paltering
pastoring12310852pastoring
pasturing1238432pasturing
pattering122314432pattering
pestering122315662pestering
plastering1339242plastering
remastering1446842remastering
sistering101213752sistering
smattering1397582smattering
tattering102212332tattering
waitering13310722waitering
watering122316322wa_tering
westering132112642westering
yattering132410452yattering
absterging1453353absterging
adhering1338883_adhering
angering102113803_angering
answering1345803answering
anteing8312813_ante_ing
ashlering1344153_ashlering
aspersing1237603_aspersing
aspiring1138873_aspiring
asserting1038663_asserting
assuring937773_assuring
asteria7316203_asteri_a
asterias8317043_asterias
asterisk1248693_asterisk
asterism10413273_asterism
astern64815813_aster_n_
astringe938223_ast_ringe
attiring939483_attiring
bacterin12410283bacterin_
bacterins13410653bacterins
badgering1436973badgering
bannering12208813bannering
barbering14229693barbering
basseting1236153basseting
basting104227203bast__ing
battening12268863battening
bettering122212763bettering
bittering122512003bittering
blattering13108723blattering
blistering13107063blistering
blustering13106183blustering
bolstering1346883bolstering
buttering122312533buttering
cambering16109873cambering
cankering162110793cankering
capering132414963ca_pering
capturing1436623capturing
careering12311203careering
cashiering1643783cashiering
casketing1635383casketing
casting104628343cast__ing
castling11311233cast_ling
centering122915143centering
chaptering18107963chaptering
chartering16109253chartering
chastening1656523chastening
chattering16108643chattering
clattering13109233clattering
clustering13116813clustering
coshering15510023coshering
cratering12312653cratering
dackering1737393dackering
daggering13246113daggering
daikering1536103daikering
dandering122511063dandering
dangering12239303dangering
eastern74412533easter_n_
easting84924303east__ing
entering91920053_entering
factoring1537543factoring
fastenings14273913fastenings
fasting114522833fast__ing
fathering161010093fathering
fattening13287833fattening
fettering132310513fettering
filtering13199723filtering
flattering1498743flattering
flustering14105933flustering
fosterling1445173fosterling
gandering122111293gandering
garnering11298093garnering
gasting95022763gast__ing
gastrin839833gast_rin_
gastrins9310133gast_rins
gathering1499463gathering
gesturing1136653gesturing
gettering112310033gettering
glistering12106423glistering
guttering112410443guttering
hammering1737633hammering
hampering1738863hampering
hamstring1546003hamst_ring
hankering17239383hankering
hasting114725193hast__ing
havering152211053ha_vering
holstering1447083holstering
hosteling1337893hosteling
jabbering2134443jabbering
jittering17218423jittering
koshering1735363koshering
laagering1136833laagering
lackering1639383lackering
laddering1237593laddering
lagering102212313la_gering
lappering14258843lappering
lasting84725243last__ing
latening9711493la_tening
lathering13912253lathering
laveering1336813laveering
lawyering1655213lawyering
layering122310353la_yering
leistering1147983leistering
lettering102112073lettering
listening10128953listening
littering102411983littering
lobstering1345123lobstering
loitering1039683loitering
lustring9269723lust_ring
maddening1445113maddening
majoring1836363ma_joring
malting103219083malt__ing
mantling112012613mant_ling
manuring1139223ma_nuring
marketing1636513marketing
marring103319553ma__rring
marting103325013mart__ing
marveling1537103marveling
mascaraing1544253mascaraing
mashing134422243mas__hing
masking145116613mas__king
masoning1139763mas_oning
massacring1543593massacring
massaging1346353massaging
massing104318023mas__sing
master84831343master___
masterdom1444393masterdom
mastered112614013master_ed
masterful1443663masterful
masterly13317653master_ly
masterminds16102413masterminds
masters94628923master__s
mastersinger1561333mastersinger
mastery124214323master__y
mastheading1843583mastheading
matching163512393ma_tching
material10314113ma_terial
materiel10311263ma_teriel
mating94832913ma_t__ing
matting103620143ma_t_ting
maundering1455353maundering
meandering1446983meandering
measuring1236123meas_uring
mentoring1239543mentoring
metring103215293m_et_ring
ministering1445543ministering
misaltering1445123misaltering
misentering1446383misentering
misfiring1536973misfiring
mishearing1647883mishearing
missteering1444453missteering
mistaking1699693mistaking
mistending1447953mistending
mistiming1438913mistiming
misting103623383mist__ing
mistuning1237673mistuning
mistyping1744723mistyping
mitring103514143m_it_ring
moistening1346233moistening
moldering1367863moldering
mongering13310353mongering
mortaring1237943mortaring
moseying1436853mos_eying
mothering152110183mothering
motoring11410953m_otoring
murdering1357133murdering
murthering1644473murthering
musteline1146973musteline
musting103221073must__ing
mysteries141211193mysteries
neutering1038963neutering
outmastering1552963outmastering
oysterings1443903oysterings
pampering1638383pampering
pandering133211963pandering
papering132213313pa_pering
partnering1345553partnering
passerine1147083passerine
pastern94415063paster_n_
pasterns104112623paster_ns
pasting103826553past__ing
patterning1346073patterning
paupering1437273paupering
peltering122011673peltering
petering112516813_petering
plaistering1444613plaistering
plasterings1444743plasterings
portering122012303portering
posturing1238993posturing
pottering122612003pottering
puttering122611643puttering
quartering2045853quartering
rapturing1245363rapturing
rattening10288763rattening
realtering1139473realtering
restoring10314613restoring
restring91518783rest_ring
roistering1148593roistering
roystering1445413roystering
sabering112113743sa_bering
saggering12197793saggering
sauntering1137223sauntering
sauteing937913saute_ing
scattering1398013scattering
sering74731813__s_ering
shattering1498283shattering
sintering101014803sintering
smartening1344993smartening
smatterings14103843smatterings
spattering13107793spattering
staring84527053__staring
steering93916793__steering
sterling93615553__sterling
stewing113412493__stewing
storing83921123__storing
string75327563__st_ring
tabering112211423ta_bering
tampering1438453tampering
tapering112112503ta_pering
tasseling1035853tasseling
tasting84624213tast__ing
tautening1035843tautening
teetering10239893teetering
tentering102313213tentering
tittering102310313tittering
tottering10229613tottering
unstring9312093unst_ring
upstaring1235963upstaring
ushering1258923_ushering
uttering91613083_uttering
vesturing1337203vesturing
wafering15208893wa_fering
wagering13219523wa_gering
wandering143310983wandering
wasterie111211593wasteri_e
wasteries121115363wasteries
wasting114422843wast__ing
waterings13229263wa_terings
wavering152410543wa_vering
weltering13219493weltering
wintering13412363wintering
yabbering1734023yabbering
yammering1735193yammering

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.406440125.6
2DLD Change Limit1486412857.36020195.8
3Display Results2852850.1232317.1
 (SQL Overall)1786912857.88922650.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.