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

492 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
mastics11261478(None) 
mastic103119171mastic_
mystics14279101mystics
antics84621452_antics
asdics9439862_asdics
aspics104211562_aspics
attics84413282_attics
basics104915122bas_ics
bustics11810882bustics
caustics1237482caustics
clastics122811412clastics
elastics102710882elastics
fustics1279592fustics
maftirs1236042maftirs
magics115311612ma_gics
manics103919932ma_nics
mantic104120902mantic_
mantids103113622mantids
mantis83926032manti_s
martins93322062martins
mashies12318252mashies
masjids17175402masjids
massifs1237742massifs
masters94628922masters
mastiche1547172mastiche
mastiches1647332mastiches
mastiff1538162mastiff
mastiffs1644232mastiffs
masting104325822masting
mastitis1039102mastitis
mastix152310502masti_x
mastixes1738252mastixes
mastoids1177872mastoids
masts77035762mast__s
matins84527782ma_tins
mattins93316142mattins
miotics112710652miotics
monastics1346792monastics
mosaics1138072mosaics
musics103911782mus_ics
myotics14257592myotics
mystic132711642mystic_
nastic82915972nastic_
nasties73520492nasties
pasties94529812pasties
pastils94416172pastils
pastis84924322pasti_s
plastics122412322plastics
rustics9810732rustics
spastics1237502spastics
tactics1149322tactics
actins86321103_actins
amities9317383amities
antic75728863_antic_
antick124814583_antick
anticks134612253_anticks
antis55033313_anti_s
arctics1138953arctics
ascetics1247073_ascetics
asdic83814093_asdic_
aspic95114733_aspic_
aspis74618143_aspi_s
asters65631603_asters
astir55517093_asti_r
astrict9614783_astrict
astricts1049453_astricts
attic75618353_attic_
banties94324763banties
basic96220523bas_ic_
basils85717473bas_ils
basins85722763bas_ins
basis75429863bas_i_s
basters94930303basters
bastes85330383bast_es
bastile9313913bastile
bastiles10313353bastiles
basting104227203basting
bastings114214693bastings
bastion9312473bastion
bastions10411693bastions
basts75936933bast__s
batiks1239373ba_tiks
battiks1337143battiks
bawties124214313bawties
beasties102514653beasties
bestirs9311133bestirs
biotics113812173biotics
blasties102113623blasties
bustic101012693bustic_
cantic103920533cantic_
caseic103212373caseic_
caseins93115053caseins
casitas93312043casitas
cassias93514343cassias
cassis84818853cassi_s
casters94729893casters
castes85631863cast_es
casting104628343casting
castings113614053castings
castles94917733castles
castors94919433castors
casts77237793cast__s
catties94023053catties
caustic1139743caustic_
classics12418873classics
clastic113013953clastic_
clitics11279973clitics
cretics112911653cretics
critics112811093critics
cystic132710653cystic_
darics94314113da_rics
dashis104414393dashi_s
dassies84418663dassies
dauties83315763dauties
dawties113312703dawties
distich13312173distich
distichs1447633distichs
distils83015803distils
domestics1446103domestics
drastic10310863drastic_
easies64126633eas_ies
easters75125683easters
easting84924303easting
eastings93412953eastings
easts57530323east__s
ekistics1485703ekistics
elastic93013393elastic_
elastins82111733elastins
emetics11610723emetics
eristics10610193eristics
erotics91914153erotics
exotics16229193exotics
fabrics1436093fabrics
fanatics1367183fanatics
fanfics1535173fanfics
fascias1258413fascias
fastens105511753fastens
fasting114522833fasting
fastings124011943fastings
fasts86429683fast__s
fatties103018203fatties
fistic11812573fistic_
fustic11910633fustic_
garlics1038013garlics
gaskins123510773gaskins
gasters85624283gasters
gasting95022763gasting
gastric1038623gastric_
gastrins9310123gastrins
gasts66628633gast__s
gestic9312773gestic_
gnostics1146313gnostics
gymnastics1851643gymnastics
haptic13511883haptic_
hastens106214813hastens
hastes95727073hast_es
hastier103916623hastier
hastiest112916493hastiest
hastily133010663hastily
hasting114725193hasting
hematics151712193hema_tics
iambics13425643iambics
instils7811453instils
isatins7310773isatins
jasmins1637083jasmins
jassids1586143jassids
justice1637423justice
justices1737523justices
karstic1357983karstic_
lactic10713493lactic_
laics76419253la__ics
laities7320343laities
lashins103915153lashins
lassies74420103lassies
lassis65216703lassi_s
lasters75627693lasters
lasting84725243lasting
lastings94214423lastings
lasts57731263last__s
latices9313763la_tices
lattice938433lattice
lattices1038383lattices
lattins74115483lattins
luetics937323luetics
macs86742503ma___cs
madtoms1236923madtoms
maestros1046163maestros
maffias15327283maffias
maffick2143523maffick
mafficks2243173mafficks
mafias113913573ma_fias
mafic125615463ma_fic_
maftir1136493mafti_r
magic105818653ma_gic_
magnetics1447163magnetics
magpies12310363magpies
mahlstick2052193mahlstick
mahlsticks2151853mahlsticks
maids86327143ma__ids
mails76037783ma__ils
maims96321793ma__ims
mains75635103ma__ins
mairs76228303ma__irs
maists85817573maist__s
majestic1944913majestic_
majesties1845373majesties
malic94525653ma_lic_
malice104818483ma_lice
malices114316623ma_lices
malkins133311803malkins
malteds10377603malteds
malthas1237913malthas
maltier93015483maltier
maltiest102916193maltiest
malting103219083malting
maltols939403maltols
malts76331753malt__s
mamies104626243ma_mies
mammies104314763mammies
maniacs114313063maniacs
manias84029033ma_nias
manic94629433ma_nic_
maniocs113611443maniocs
manitos9314053manitos
manitus9310923manitus
mantas85725363mant_as
mantels94515043mantels
mantes84430783mant_es
mantid93820373manti_d
mantises10317923mantises
mantissa1044573mantissa
mantles94820703mantles
mantras93815863mantras
mantric11311333mantric_
mantuas93410993mantuas
maquis17249483maqui_s
marcs95726623ma__rcs
margins103815193margins
marlins93420473marlins
marries93825283marries
martens93714953martens
martial92415413martial
martian93514683martian
martians103111613martians
martin84122523marti_n
marting103325013marting
martini93613873martini
martinis103311613martinis
marts77442233mart__s
martyrs1234893martyrs
masalas9312053masalas
masas75630413mas__as
mascons113411583mascons
mascots113910343mascots
masers84623453mas_ers
mashers124621053mashers
mashes115030003mas_hes
mashie11315933mashi_e
mashing134422243mashing
masjid16187313masji_d
maskegs14375413maskegs
maskers133913833maskers
masking145116613masking
maskings15448743maskings
masks115320533mas__ks
masonic1139913masonic_
masons83916513mas_ons
masques18239363masques
mass66044933mas___s
massas85116463mas_sas
masses85028713mas_ses
massicot1246583massicot
massicots1343843massicots
massier93615223massier
massiest103314423massiest
massif11412533massi_f
massing104318023massing
massive12289773massive
mast65959953mast___
mastaba1146223mastaba
mastabas1246803mastabas
masted94025803mast_ed
master84831343mast_er
masteries111018493masteries
mastery124214323mastery
masticate13411283masticate
masticates1449843masticates
mastitic1248263mastitic
mastless102610023mastless
mastlike1437863mastlike
mastoid10711223mastoid
match125621103ma_t_ch
maters85032383ma_ters
mates75251363ma_t_es
mateys115610943ma_teys
maths105624023ma_t_hs
matier84321523ma_tier
matiest92522453ma_tiest
matin75132853ma_ti_n
mating94832913ma_ting
matings104516203ma_tings
matres84522233ma_tres
matrices12312083matrices
mats65460283ma_t__s
matsahs1236563matsahs
matters94421753matters
mattes85624533ma_ttes
mattin84416633matti_n
matting103620143matting
mattings11369673mattings
mattock1535823mattock
mattocks1644983mattocks
mattoids1196183mattoids
matts76829183ma_t_ts
matzas1749703ma_tzas
matzos1749263ma_tzos
maulstick1742723maulstick
maulsticks1852073maulsticks
mauts75927193maut__s
mavies114923193ma_vies
mavins115119183ma_vins
mavis105622723ma_vi_s
maxims17399673ma_xims
maxis145721563ma_xi_s
mayvins1535323mayvins
medics114115353m_edics
memetics1447803memetics
mesic93617863mes_ic_
mestees94617753mestees
mestino9411643mestino
mestinos1048163mestinos
mestiza1835383mestiza
mestizas1944693mestizas
mestizo1845943mestizo
mestizos1944493mestizos
metis75025903m_eti_s
metrics11312363metrics
miasmic1335743miasmic_
mics87435153m___ics
mimics1289363m_imics
miotic103715743miotic_
misaims11310113misaims
misbias1139083misbias
misfits12279663misfits
mishits122513083mishits
miskick1435613miskick
miskicks1544763miskicks
mislies92922283mislies
missies93423983missies
missis84417503missi_s
misters93927503misters
mistier93418713mistier
mistiest103018313mistiest
mistily122612343mistily
mistime11312613mistime
mistimes12612613mistimes
misting103623383misting
mists76633903mist__s
mitis75425993m_iti_s
monastic1249863monastic_
mortice11711493mortice
mortices12711553mortices
mosaic10311143mosaic_
mosts76028543most__s
motifs1139673m_otifs
muftis1158053mufti_s
muntins92715133muntins
muscids12187973muscids
music94316403mus_ic_
musick14408703mus_ick
musicks15297053mus_icks
musjids17185713musjids
muskies133614663muskies
muskits13278553muskits
muslins9312213muslins
mustees94614923mustees
musters94522493musters
musths11589483must_hs
mustier94017953mustier
mustiest103017533mustiest
mustily123613633mustily
musting103221073musting
musts75527443must__s
myasis114010463myas_i_s
myotic133112303myotic_
mysids1246563mys_ids
mystical1546933mystical
mysticism1845383mysticism
mysticly1843323mysticly
mystify1843563mystify
nastier74115293nastier
nastiest83615953nastiest
nastily103011033nastily
nostocs947543nostocs
oasis56422553oas_i_s
oasts56529183oast__s
onomastics1453833onomastics
optics102810183_optics
osmics1036463_osmics
panics103815363pa_nics
panties94230933panties
paretics122312443paretics
parties93230863parties
pastas85422873past_as
pastels95215183pastels
pasters94531733pasters
pastes85233913past_es
pasticci1443823pasticci
pastiche1546933pastiche
pastiches1637453pastiches
pastie85525523pasti_e
pastier94320383pastier
pastiest103319543pastiest
pastil85018323pasti_l
pastime114611973pastime
pastimes123611903pastimes
pastina93914593pastina
pastinas103712153pastinas
pasting103826553pasting
pastises103616053pastises
pastitso1043623pastitso
pastors94118993pastors
pastries101517423pastries
pasts75936503past__s
patins87528783pa_tins
patios85221783pa_tios
patsies93919483patsies
patties93425143patties
peptics132610243peptics
photics142810473photics
pistils93314303pistils
plastic112815063plastic_
plastids11269203plastids
poetics11312073poetics
posties93128813posties
postins93721203postins
quantics19276833quantics
quartics19216843quartics
ramtils938413ramtils
rasters74629023rasters
ratios64922673ra_tios
romantics1346773romantics
rustic8712673rustic_
salties73725773salties
santims9312593santims
santirs7312963santirs
sasins64923103sas_ins
sassies74719263sassies
satins64930483sa_tins
satis55633673sa_ti_s
semantics1346823semantics
septics112810433septics
sics65234093__s_ics
smarties10312873smarties
spastic11310373spastic_
spics94123243__spics
statics93314533statics
stich104117923__stich
stichs114511653__stichs
stick115121563__stick
sticks125118613__sticks
sties55132983__sties
stirs55921613__stirs
stoics8311113__stoics
swastica1384153swastica
swasticas1493803swasticas
tabetics1245683tabetics
tactic10612753tactic_
tassies74918933tassies
tasters74225643tasters
tastes64126423tast_es
tastier711817093tastier
tastiest83216633tastiest
tastily103311643tastily
tasting84624213tasting
tatties74120343tatties
testis64916713testi_s
tics65729633___tics
unstick1338123unstick
unsticks1436233unsticks
upstirs935293upstirs
vastier103613203vastier
vastiest112713073vastiest
vastity1336203vastity
vasts86423773vast__s
vatic10316423va_tic_
wasters104026593wasters
wastes96224883wast_es
wasting114422843wasting
wastries111212883wastries
wasts87433673wast__s
yautias1046333yautias

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274926.67020094.0
3Display Results4924920.1732843.9
 (SQL Overall)1786914926.99925530.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.