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

430 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
mastix15231051(None) 
mastic103119171mastic
astir55517092_astir
maftir1136492maftir
mantic104120902mantic
mantid93820382mantid
mantis83926032mantis
martin84122522martin
mashie11315932mashie
masjid16187322masjid
massif11412532massif
mast65959962mast__
masted94025802masted
master84831342master
mastics112614782mastics
mastiff1538162mastiff
masting104325822masting
mastixes1738252mastixes
mastoid10711232mastoid
masts77035762mast_s
matin75132852ma_tin
matrix1539842matrix
mattin84416632mattin
mystic132711642mystic
nastic82915972nastic
pastie85525522pastie
pastil85018322pastil
pastis84924322pastis
actin74922553_actin
admix1557733_admix
affix1836003_affix
anti45536363_anti_
antic75728863_antic
antis55033313_antis
asci66519143_asci_
asdic83814093_asdic
aspic95114733_aspic
aspis74618143_aspis
aster55434893_aster
attic75618353_attic
basic96220523bas_ic
basil75122273bas_il
basin75026923bas_in
basis75429863bas_is
bassi77019323bassi_
bast66362413bast__
baste74829983bast_e
basted95227233basted
baster85333593baster
bastes85330383bastes
bastile9313913bastile
basting104227203basting
bastion9312473bastion
basts75936933bast_s
batik11614733ba_tik
battik1238093battik
bawtie113812143bawtie
beastie92412433beastie
bestir8311163bestir
blastie92411393blastie
bustic101012693bustic
cacti9318643cacti_
calix145317353ca_lix
cantic103920543cantic
caseic103212373caseic
casein83216453casein
casita82913703casita
cassia83714763cassia
cassis84818853cassis
cast67159903cast__
caste75932363cast_e
caster85232573caster
castes85631863castes
casting104628343casting
castle84918963castle
castor84418533castor
casts77237793cast_s
cattie85221023cattie
caustic1139753caustic
cesti75217423cesti_
clastic113013963clastic
cystic132710653cystic
dashi95013113dashi_
dashis104414393dashis
dassie74615573dassie
dautie72914703dautie
dawtie103011093dawtie
distil73616433distil
drastic10310873drastic
east46659103east__
easter65027983easter
easting84924303easting
easts57530323east_s
elastic93013393elastic
elastin72611843elastin
fascia1148703fascia
fast77052313fast__
fasted105320953fasted
fasten95114893fasten
faster94625773faster
fasting114522833fasting
fasts86429683fast_s
fistic11812573fistic
fustic11910633fustic
gaskin113610583gaskin
gaslit7513503gaslit
gast56052563gast__
gasted84821583gasted
gaster75027353gaster
gasting95022763gasting
gastric1038633gastric
gastrin839833gastrin
gasts66628633gast_s
gestic9312773gestic
haptic13511893haptic
hast76259483hast__
haste85927863hast_e
hasted105125283hasted
hasten95718563hasten
hastes95727073hastes
hastier103916623hastier
hastily133010663hastily
hasting114725193hasting
hasty115718763hast_y
instil61111383instil
isatin6412213isatin
jasmin1538073jasmin
jassid1467223jassid
karstic1357983karstic
lactic10713493lactic
lassi56316853lassi_
lassie64917743lassie
lassis65216703lassis
last46260323last__
lasted74323603lasted
laster64830633laster
lasting84725243lasting
lastly93310873lastly
lasts57731263last_s
latex124717113la_tex
lati46438273la_ti_
lattin64316223lattin
madtom1138023madtom
maestri945483maestri
maestro945723maestro
maffia14327203maffia
mafia104418033ma_fia
mafic125615463ma_fic
maftirs1236043maftirs
magi76329533ma_gi_
magic105818653ma_gic
magpie1139093magpie
maid75537663ma__id
mail65543453ma__il
maim85831493ma__im
main65345523ma__in
mair66133783ma__ir
maist75535683maist__
maists85817573maist_s
majestic1944913majestic
malic94525663ma_lic
malkin122913153malkin
maloti8313213maloti_
malt66254813malt__
malted94819863malted
maltha1137503maltha
maltier93015483maltier
malting103219083malting
maltol8310843maltol
malts76331753malt_s
malty106721703malt_y
mamie95826003ma_mie
mammie94313783mammie
mania75634153ma_nia
manic94629443ma_nic
manito8518693manito
manitu8315823manitu
manta75629913mant_a
mantas85725363mantas
mantel84317973mantel
mantes84430783mantes
mantids103113623mantids
mantle84420923mantle
mantra84116093mantra
mantric11311343mantric
mantua84412023mantua
maqui16249953maqui_
maquis17249483maquis
margin94016843margin
maria75032883ma_ria
marlin84220903marlin
mart66865983mart__
marted94425213marted
marten84518263marten
martial92415413martial
martian93514683martian
marting103325013marting
martini93613873martini
martins93322063martins
marts77442233mart_s
martyr1135693martyr
mas58175823mas___
masa65034723mas__a
masala8311813masala
masas75630413mas_as
mascon103612743mascon
mascot104016073mascot
maser75029973mas_er
masers84623453masers
mash96039403mas__h
mashed125325043mashed
masher114123203masher
mashes115030003mashes
mashies12318253mashies
mashing134422243mashing
mashy136016503mas_hy
masjids17175403masjids
mask105227363mas__k
masked134316523masked
maskeg13388693maskeg
masker124416103masker
masking145116613masking
masks115320533mas_ks
mason74820183mas_on
masonic1139913masonic
masons83916513masons
masque17249383masque
mass66044943mas__s
massa75518923mas_sa
massas85116463massas
masse75125293mas_se
massed94421323massed
masses85028713masses
massier93615223massier
massifs1237743massifs
massing104318023massing
massive12289773massive
massy104518963mas_sy
mastaba1146223mastaba
masters94628923masters
mastery124214323mastery
mastiche1547173mastiche
mastiffs1644233mastiffs
mastitic1248263mastitic
mastitis1039103mastitis
mastlike1437863mastlike
mastoids1177873mastoids
mat58083943ma_t__
match125621103ma_tch
mate65154223ma_t_e
mated85537783ma_ted
mater74438863ma_ter
mates75251363ma_tes
matey107022663ma_tey
math95437453ma_t_h
maths105624023ma_ths
matier84321523ma_tier
mating94832913ma_ting
matins84527783ma_tins
mats65460293ma_t_s
matsah1138233matsah
matt65752663ma_t_t
matte75626843ma_tte
matted94521413matted
matter84325343matter
mattes85624533mattes
matting103620143matting
mattins93316143mattins
mattoid1079283mattoid
matts76829183ma_tts
matza16311813ma_tza
matzo16312893ma_tzo
maut65448453maut__
mauts75927193maut_s
mavie104722563ma_vie
mavin105722953ma_vin
mavis105622723ma_vis
max129045453ma___x
maxi137023563ma_xi_
maxim165216003ma_xim
maxis145721563ma_xis
maxixe1435223ma_xixe
mayst106622673mayst__
mayvin1436523mayvin
mesic93617863mes_ic
mestee84523883mestee
mestino9411643mestino
mestiza1835383mestiza
mestizo1845943mestizo
metis75025903m_etis
miasmic1335743miasmic
miotic103715753miotic
misaim10311853misaim
misdid10510573misdid
misfit112813833misfit
mishit112618193mishit
mislie83219153mislie
mislit83019693mislit
missis84417503missis
mist66154533mist__
misted93625823misted
mister84728563mister
mistier93418713mistier
mistily122612343mistily
mistime11312613mistime
misting103623383misting
mists76633903mist_s
misty106120453mist_y
mitis75425993m_itis
mix126138183m___ix
monastic1249863monastic
mosaic10311143mosaic
most66554203most__
moste75925083most_e
mostly113110943mostly
mosts76028543most_s
motif10519683m_otif
mufti10610543mufti_
muftis1158053muftis
muntin82915183muntin
muscid11219833muscid
music94316403mus_ic
musjid16216953musjid
muskie123412543muskie
muskit122813253muskit
muskox1933953muskox
muslin8312213muslin
must65145443must__
musted93321073musted
mustee83922103mustee
muster84724523muster
musth105314783must_h
musths11589483musths
mustier94017963mustier
mustily123613633mustily
musting103221073musting
musts75527443must_s
musty105620953must_y
myasis114010473myas_is
myotic133112313myotic
mysid11610693mys_id
mystics14279103mystics
mystify1843563mystify
nastier74115293nastier
nasties73520493nasties
nastily103011033nastily
nasty85717283nast_y
oasis56422553oas_is
oast47156323oast__
oasts56529183oast_s
ostia52315583_ostia
pantie84326473pantie
passim10410283passim
past65959013past__
pasta76624533past_a
pastas85422873pastas
paste74932953past_e
pasted94426903pasted
pastel85918713pastel
paster85734373paster
pastes85233913pastes
pastier94320383pastier
pasties94529813pasties
pastils94416173pastils
pastime114611973pastime
pastina93914593pastina
pasting103826553pasting
pastor84817483pastor
pastry114913033pastry
pasts75936503past_s
pasty105725053past_y
patin76832853pa_tin
patio74426353pa_tio
pattie84020963pattie
pistil83915073pistil
plastic112815063plastic
plastid102112523plastid
postfix1944683postfix
postie84123963postie
postin83521033postin
radix134414603ra_dix
ramtil8311023ramtil
raster64731443raster
ratio55227583ra_tio
rustic8712673rustic
saltie63422433saltie
santir6315253santir
sasin54626573sas_in
sati45539333sa_ti_
satin55935223sa_tin
satis55633683sa_tis
six105339743__s_ix
smalti84111193smalti_
smartie9310173smartie
spastic11310383spastic
stir45723253__stir
tactic10612753tactic
tassie66017023tassie
taste55127233tast_e
tasted74123973tasted
taster64930573taster
tastes64126423tastes
tastier711817093tastier
tastily103311643tastily
tasting84624213tasting
tasty84820313tast_y
tattie64817513tattie
testis64916713testis
upstir835383upstir
varix154313513va_rix
vast75045123vast__
vaster94521023vaster
vastier103613203vastier
vastity1336203vastity
vastly12508723vastly
vasts86423773vast_s
vasty116215923vast_y
vatic10316423va_tic
wast75655853wast__
waste86125053wast_e
wasted104423023wasted
waster95228943waster
wastes96224883wastes
wasting114422843wasting
wastrie101210303wastrie
wastry12388773wastry
wasts87433673wast_s
xysti15538153xysti_
yautia937253yautia
zaftig1933253zaftig

Search took 6 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 Filter1786911127160.1231452772.4
2DLD Change Limit1127164304.86023192.6
3Display Results4304300.1403071.4
 (SQL Overall)1786914305.12334880.1
 
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.