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

255 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
mastixes173825(None) 
bastiles10313352bastiles
mantises10317922mantises
mashies12318252mashi_es
mastiches1647332mastiches
mastics112614782masti_cs
mastiffs1644232mastiffs
mastitis1039102mastitis
mastix152310512mastix__
matrixes1738062matrixes
maxixes1535252ma_xixes
mistimes12612612mistimes
nasties73520492nasti_es
pasties94529812pasti_es
pastimes123611902pastimes
pastises103616052pastises
actives12311523_actives
admixes1765963_admixes
affixes2035503_affixes
amities9317383amiti_es
ascites9312603_ascites
asides75118873_as_ides
aspires9612043_aspires
aspises9611643_aspises
assizes1638453_assizes
astilbes1044733_astilbes
attires72312953_attires
banties94324763banti_es
baptises1238923baptises
baptizes2136843baptizes
bastes85330383bast__es
bastile9313913bastile_
bastilles1147353bastilles
bastings114214693bastings
bastions10411693bastions
bawties124214313bawti_es
beasties102514653beasti_es
blasties102113633blasti_es
captives1538623captives
cassines103116613cassines
cassises103811743cassises
castes85631863cast__es
castings113614053castings
castles94917733cast_les
catties94023053catti_es
chastises1437703chastises
cystines1339473cystines
dassies84418663dassi_es
datives11310073da_tives
dauties83315763dauti_es
dawties113312703dawti_es
daytimes1434483daytimes
destines93619663destines
easies64126633eas_i_es
eastings93412953eastings
fascines13310143fascines
fastings124011943fastings
fatties103018203fatti_es
hastes95727073hast__es
hastier103916623hasti_er
hastiest112916493hasti_est
hastiness122410883hastiness
hostiles11312213hostiles
isatines8310663isatines
jasmines1736623jasmines
justices1737523justices
laities7320343laiti_es
lassies74420103lassi_es
lastings94214423lastings
latexes1438313la_texes
latices9313763la_tices
lattices1038383lattices
machines15312893machines
maftirs1236043mafti_rs
magpies12310363magpi_es
mailes84329113ma__iles
maizes175115733ma__izes
majesties1845373majesti_es
malaises10312333malaises
malices114316623ma_lices
malines93625603ma_lines
maltases1039693maltases
maltier93015483malti_er
maltiest102916193malti_est
maltiness112910573maltiness
maltoses1039853maltoses
mamies104626243ma_mi_es
mammies104314763mammi_es
mannites10312613mannites
mantes84430783mant__es
mantids103113623manti_ds
mantis83926033manti__s
mantles94820703mant_les
marines93928013ma_rines
marlines103818713marlines
marlites103415263marlites
marmites122212793marmites
marries93825283marri_es
martians103111613martians
martinet10319643martinet
martinets1138883martinets
martinis103311613martinis
martins93322063marti_ns
mashes115030003mas__hes
mashie11315933mashi_e_
masjids17175403masji_ds
maskings15448753maskings
masonites1149173masonites
masques18239363mas_ques
massages1159883massages
masses85028713mas__ses
massier93615223massi_er
massiest103314423massi_est
massifs1237743massi_fs
massiness112810143massiness
massive12289773massive_
mastabas1246803mastabas
masted94025803mast__ed
master84831343mast__er
mastered112614003mastered
masteries111018493masteries
masters94628923mast_ers
mastic103119173masti__c
masticates1449843masticates
mastiche1547173mastiche
mastiff1538163masti_ff
masting104325823masti_ng
mastitic1248263mastitic
mastitides1345833mastitides
mastless102610023mastless
mastlike1437863mastlike_
mastoids1177873mastoids
masts77035763mast___s
matches143219783ma_tches
mates75251363ma_t__es
matier84321523ma_ti_er
matiest92522453ma_ti_est
matinee92415613ma_tinee
matinees102110423ma_tinees
matiness102114753ma_tiness
matings104516213ma_tings
matins84527783ma_ti_ns
matres84522233ma_t_res
matrices12312083matrices
mattes85624533ma_t_tes
mattings11369673mattings
mattins93316143matti_ns
matures9314303ma_tures
mavies114923193ma_vi_es
mavises122812993ma_vises
maxes145629533ma___xes
maxixe1435223ma_xixe_
mealtimes1345243mealtimes
meantimes1345883meantimes
mestees94617753mest_ees
mestinoes1157313mestinoes
mestinos1048163mestinos
mestizas1944703mestizas
mestizoes2064173mestizoes
mestizos1944493mestizos
miscites12313783miscites
misfiles133110983misfiles
misfires132210583misfires
misgives14329293misgives
mislies92922283misli_es
mislikes143311833mislikes
mislives132912153mislives
missies93423983missi_es
missiles103015083missiles
missises103513693missises
missives133212843missives
mistakes141213413mistakes
mistier93418713misti_er
mistiest103018313misti_est
mistime11312613mistime_
mistimed1339123mistimed
mistiness111911633mistiness
mistitles1147953mistitles
mistunes10311133mistunes
mistypes15116713mistypes
mitises9315543m_itises
mixes147224403m___ixes
mortices12711563mortices
mortises10713613mortises
motiles93317433m_otiles
motives123611893m_otives
muskies133614673muski_es
muspikes1635243muspikes
mustees94614923must_ees
mustier94017963musti_er
mustiest103017533musti_est
mustiness112211663mustiness
mutines93117823m_utines
mystics14279103mysti_cs
mystifies1745883mystifies
mystiques2342423mystiques
nastier74115293nasti_er
nastiest83615953nasti_est
nastiness92310573nastiness
natives10310823na_tives
panmixes1934913panmixes
panties94230933panti_es
pantiles103617153pantiles
parties93230863parti_es
passives13228823passives
pastes85233913past__es
pastiches1637453pastiches
pastie85525523pasti_e_
pastier94320383pasti_er
pastiest103319543pasti_est
pastilles1148703pastilles
pastils94416173pasti_ls
pastime114611973pastime_
pastinas103712153pastinas
pastiness112312353pastiness
pastis84924323pasti__s
pastries101517423pastries
pastures10311963pastures
patines95225763pa_tines
patsies93919483patsi_es
patties93425143patti_es
postfixes2164473postfixes
posties93128813posti_es
radixes15259343ra_dixes
ragtimes1135823ragtimes
ratines75328583ra_tines
ratites74920683ra_tites
salties73725773salti_es
saltines82917793saltines
saltires83112423saltires
sassies74719263sassi_es
satires72617573sa_tires
sestines82717243sestines
sixes124526363__s_ixes
smaltines1136993smaltines
smaltites1145743smaltites
smarties10312873smarti_es
sties55132983__sti_es
stiles64328773__stiles
stimes85920573__stimes
stipes84524053__stipes
tassies74918933tassi_es
tastes64126423tast__es
tastier711817093tasti_er
tastiest83216633tasti_est
tastiness92311143tastiness
tatties74120343tatti_es
vastier103613203vasti_er
vastiest112713073vasti_est
vastities1248933vastities
vestiges1238243vestiges
wartimes1336963wartimes
wastages12109753wastages
wastes96224883wast__es
wastries111212883wastries

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622557.51619446.8
3Display Results2552550.0932741.9
 (SQL Overall)1786912558.01522294.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.