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

185 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
masteries11101849(None) 
mysteries141211191mysteries
wasteries121115341wasteries
arteries8321482_arteries
asterias8317012_asterias
batteries11615112batteries
catteries11815522catteries
cauteries11615392cauteries
easterlies1046712easterlies
eateries8324312ea_teries
martyries1446562martyries
masonries1146852masonries
mastered112614002master_ed
mastering122315302mastering
masters94628922master__s
materiel10311252ma_teriel
materiels1147832ma_teriels
miseries10320402mis_eries
monasteries1345942monasteries
pastries101517422past_ries
wasterie111211582wasterie_
wastries111212882wast_ries
absterges1244763absterges
aeries64737783_a__eries
amberies122514683_amberies
aperies9423203_a_peries
asperges11318093_asperges
asperses104111673_asperses
asteria7316183_asteri_a
asterisk1248673_asterisk
asterisks1346813_asterisks
asterism10413253_asterism
asterisms11511063_asterisms
asteroids1048743_asteroids
asters65631603_aster__s
asthenies1278063_asthenies
astonies8815093_astonies
bacterias1349283bacterias
bacterins13410643bacterins
bacterizes2347973bacterizes
bakeries14312193ba_keries
basketries1645043basketries
bastardies1365143bastardies
basters94930303baster__s
batterie10711533batterie_
booteries11312773booteries
brasseries1246873brasseries
butteries11711763butteries
canneries11313083canneries
casefies1339213cas_efies
casernes103810753cas_ernes
casters94729903caster__s
causeries11510643causeries
cauterizes2197993cauterizes
coteries10422703_coteries
dataries9314033da_taries
dauberies1248033dauberies
easterner945053easterner
easterners1044823easterners
easters75125683easter__s
factories14810113factories
faeries104118993fa__eries
fakeries1559833fa_keries
fisheries1548643fisheries
flatteries1347423flatteries
galleries10311713galleries
gantries91413793gant_ries
gasters85624293gaster__s
gastrins9310123gast_rins
gauderies1147743gauderies
halteres113414603halter_es
hatterias1258743hatterias
histories12412473histories
hosieries1249213hosieries
hostelries1345423hostelries
hysterias1547153hysterias
hysterics1746053hysterics
imageries1246783ima_geries
jaggeries18136973jaggeries
japeries17311463ja_peries
lamaseries1244893lamas_eries
lasters75627693laster__s
laterites9715063la_terites
laterizes18513023la_terizes
listerias959233listerias
lotteries9311073lotteries
maderizes2148953ma_derizes
marries93825283ma__rries
martyrizes2444433martyrizes
masers84623453mas_er__s
mashers124621053masher__s
mashies12318253mas__hies
maskers133913843masker__s
masseuses1144793masseuses
master84831343master___
masterdom1444393masterdom
masterdoms1544363masterdoms
masterful1443653masterful
masterliness1463833masterliness
masterly13317653master_ly
mastermind1583953mastermind
masterminds16102413masterminds
masterpiece1752043masterpiece
masterpieces1851883masterpieces
masterships1855373masterships
mastery124214323master__y
mastiches1647333mastiches
mastics112614783mast__ics
mastitides1345833mastitides
mastitis1039103mastiti_s
mastixes1738253mast_ixes
mastoids1177873mast_oids
mastopexies2251983mastopexies
material10314103ma_terial
materials11510793ma_terials
maters85032393ma_ter__s
matres84522233ma_t_r_es
matrices12312083ma_t_rices
matrixes1738063ma_t_rixes
mattered112412903matter_ed
mattering122314053mattering
matters94421753matter__s
matures9314313ma_tur_es
maumetries1446023maumetries
merceries13410043merceries
mesenteries1345893mesenteries
mesmerise1345843mesmerise
mesmerises1445823mesmerises
mesmerizes2345993mesmerizes
mestees94617753meste__es
mestesoes1145323mestesoes
midstories1345653midstories
misrelies1149723misrelies
mistermed1438363mistermed
misterms123711353mister_ms
misters93927513mister__s
mockeries17128263mockeries
monkeries15129913monkeries
moperies12313873m_operies
mummeries1247243mummeries
musketries1643303musketries
mustees94614923muste__es
mustelids1243583mustelids
mustered112511503muster_ed
mustering122212333mustering
musters94522513muster__s
mysterious1543903mysterious
mystifies1745883mystifies
naperies10313903na_peries
nasties73520493nast__ies
niteries8318383_niteries
pantries101817393pant_ries
papeteries1446553papeteries
parterres1148063parterres
passerines1246163passerines
pasterns104112623paster_ns
pasters94531733paster__s
pasteurise1244103pasteurise
pasteurises1343953pasteurises
pasteurizes2243663pasteurizes
pasties94529813past__ies
pastures10311963pastur_es
potteries11313593potteries
psalteries1276563psalteries
rasters74629023raster__s
roseries8317313ros_eries
santerias9311843santerias
sauternes947023sauternes
series64540973__s_eries
sesterces1147873sesterces
smelteries1246163smelteries
steres63929533__ster_es
stories7324273__stories
tanneries9310423tanneries
tasters74225643taster__s
tusheries1246893tusheries
vastities1248933vastities
vestries11314053vest_ries
waggeries14127463waggeries
wasters104026593waster__s
wastrie101210303wast_rie_
waterier11312083wa_terier
wateriest12312233wa_teriest
westerlies1345613westerlies
wisterias1248103wisterias

Search took 9 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.440406115.9
2DLD Change Limit1486411857.53019739.8
3Display Results1851850.0762434.2
 (SQL Overall)1786911858.04622208.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.