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

201 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
matrixes173806(None) 
matrices12312081matrices
latrines8515002latrines
marines93928012ma_rines
marries93825282marri_es
mastixes1738252mastixes
matres84522232matr__es
matrix1539842matrix__
maxixes1535252ma_xixes
admixes1765963_admixes
aeries64737783_aeri_es
affixes2035503_affixes
ambries111614553ambri_es
arises65233803_a_rises
arrises71617583_arrises
arrives101311513_arrives
ataxies142410013_ataxies
atriums939043_atriums
attires72312953_attires
attrites8311563attrites
aviatrixes2042093aviatrixes
barites94322333ba_rites
caprices1439893caprices
caribes113715643ca_ribes
carices114220953ca_rices
caries85147623ca_ri_es
carries94328013carri_es
cathexes2036273cathexes
catties94023053catti_es
cicatrixes2142583cicatrixes
citrines102513133citrines
dairies84217733dairi_es
dataries9314033datari_es
datives11310073dat_ives
diatribes1245533diatribes
eateries8324313eateri_es
editrixes1743813editrixes
entries71523163entri_es
faeries104118993faeri_es
fairies103516043fairi_es
fatties103018203fatti_es
gantries91413783gantri_es
hagrides1337623hagrides
harries103525493harri_es
hatboxes2055003hatboxes
hayrides1536883hayrides
kauries113613193kauri_es
laetriles944663laetriles
laterites9715053laterites
laterizes18513013laterizes
latexes1438313lat_exes
latices9313763lat_ices
latrias71913213latri_as
latrine7715123latrine_
lattices1038383lattices
machines15312893machines
macrames1438953macrames
maderizes2148953maderizes
madrases112610003madrases
madres93718183madr__es
madrones112912283madrones
magpies12310363magpi_es
mailes84329113ma__iles
maizes175115733ma__izes
malaises10312333malaises
malices114316623ma_lices
malines93625603ma_lines
mamies104626243ma_mi_es
mammies104314763mammi_es
mannites10312613mannites
manropes1237913manropes
mantises10317923mantises
marbles114516653ma_rbles
marches143921173ma_rches
mares76457633ma_r__es
marges94525713ma_r_ges
marinas93519383ma_rinas
marine84230403ma_rine_
mariner93315993ma_riner
mariners103113863ma_riners
marishes13512553ma_rishes
marlines103818713marlines
marlites103415263marlites
marmites122212793marmites
marques182610863ma_rques
marriages1247383marriages
married104715303marri_ed
marrieds11288073marrieds
marrier93817523marri_er
marriers103312473marriers
marses84827113ma_r_ses
marshes123615373ma_rshes
martians103111613martians
martinet10319643martinet
martinets1138883martinets
martinis103311613martinis
martins93322063marti_ns
martyries1446563martyri_es
martyrizes2444433martyrizes
mashies12318253mashi_es
masteries111018493masteri_es
matches143219783mat_ches
materials11510793materials
materiel10311253materi_el
materiels1147833materiels
mates75251363mat___es
matier84321523mat_i_er
matiest92522453mat_i_est
matinee92415613mat_inee
matinees102110423matinees
matiness102114753mat_iness
matings104516213mat_ings
matins84527783mat_i_ns
matrass939403matr_ass
matrasses1157293matrasses
matricides1545983matricides
matronizes2196823matronizes
matrons93517633matr_ons
mattes85624533mat__tes
mattings11369673mattings
mattins93316143matti_ns
maturates11311763maturates
matures9314303mat_ures
maturities1248453maturities
mavies114923193ma_vi_es
mavises122812993ma_vises
maxes145629533ma___xes
maxixe1435223ma_xixe_
mediatrixes2152593mediatrixes
merises93421423m_erises
metres85121563metr__es
metrics11312363metri_cs
metrifies1439803metrifies
metrists1039853metrists
metritis1049183metritis
mirexes1636993m_irexes
mitises9315543mit_ises
mitres83922073mitr__es
mixes147224403m___ixes
morrises10711073morrises
mortices12711563mortices
mortises10713613mortises
motiles93317433mot_iles
motives123611893mot_ives
motorises11311673motorises
motorizes20410783motorizes
murexes1636973m_urexes
murices112612283m_urices
murines93718223m_urines
murries94118673murri_es
mutines93117823mut_ines
natives10310823nat_ives
natriums1046293natriums
nitrides92910703nitrides
nitriles8269923nitriles
nitrites82313453nitrites
oratrices1145833oratrices
outrides92414993outrides
panmixes1934913panmixes
pantries101817393pantri_es
paries84742513pa_ri_es
parises94827183pa_rises
parries93925843parri_es
parties93230863parti_es
pastries101517423pastri_es
patines95225763pat_ines
patriates11311363patriates
patriots1038053patriots
patsies93919483patsi_es
patties93425143patti_es
radixes15259343ra_dixes
ratines75328583rat_ines
ratites74920683rat_ites
ratlines83815293ratlines
retries74129073retri_es
satires72617573sat_ires
satirises9410193satirises
satirizes1849393satirizes
sauries72821623sauri_es
smarties10312873smarti_es
strides84520393_strides
strifes104716583_strifes
strikes114719093_strikes
stripes95320573_stripes
strives104119373_strives
tacrines10310563tacrines
tarries73324263tarri_es
tatties74120343tatti_es
taurines8310553taurines
tortrixes1644153tortrixes
tribes85119023__tribes
trices84826333__trices
tries55742813__tri_es
trikes105419493__trikes
trines64132563__trines
tripes85324873__tripes
varices123313573va_rices
varies94330873va_ri_es
vitrines112610913vitrines
wartimes1336963wartimes
wastries111212883wastri_es

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622017.20320291.8
3Display Results2012010.0762644.7
 (SQL Overall)1786912017.70223200.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.