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

274 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
matrices1231208(None) 
matrixes1738061matrixes
caprices1439892caprices
carices114220952ca_rices
latices9313762lat_ices
latrines8515012latrines
lattices1038382lattices
malices114316622ma_lices
marines93928012ma_rines
marries93825282marri_es
matres84522232matr__es
matricides1545982matricides
metrics11312362metric_s
mortices12711562mortices
murices112612282m_urices
oratrices1145832oratrices
trices84826332__trices
varices123313572va_rices
advices13136933_advices
aeries64737783_aeri_es
ambries111614553ambri_es
amerces1149853amer_ces
amices105018013_a_mices
amtracks1696633amtracks
amtracs1198883amtrac_s
apices104916263_a_pices
arises65233803_a_rises
arrises71617583_arrises
arrives101311513_arrives
articles10310243_articles
astricts1049463astricts
atriums939043_atriums
attics84413283_attic_s
attires72312953_attires
attrites8311563attrites
auricles10138333_auricles
avarices1337183avarices
aviatrices1543163aviatrices
barites94322333ba_rites
brattices1345553brattices
caddices14297853caddices
calices114321693ca_lices
caprice1349683caprice_
caribes113715643ca_ribes
caries85147623ca_ri_es
carries94328013carri_es
catfaces1536963catfaces
catties94023053catti_es
caudices13337343caudices
cicatrices1343493cicatrices
citrines102513133citrines
cortices12615013cortices
dairies84217733dairi_es
darics94314113da_ric_s
dataries9314033datari_es
datives11310073dat_ives
diatribes1245533diatribes
eateries8324313eateri_es
editrices1245323editrices
entices91616333ent_ices
entries71523163entri_es
fabrics1436093fabric_s
faeries104118993faeri_es
fairies103516043fairi_es
farces115223323fa_r_ces
farcies125317883fa_rcies
fatties103018203fatti_es
gantries91413793gantri_es
gentrices1258913gentrices
hagrides1337623hagrides
harries103525493harri_es
hatracks1737533hatracks
hayricks2043763hayricks
hayrides1536883hayrides
iatric8312173iatric__
iatrical1049273iatrical
kauries113613193kauri_es
laetriles944673laetriles
laterites9715063laterites
laterizes18513023laterizes
latrias71913213latri_as
latrine7715133latrine_
lattice938433lattice_
latticed1134793latticed
maces97139963ma___ces
machines15312893machines
macrames1438953macrames
maderizes2148953maderizes
madrases112610003madrases
madres93718183madr__es
madrones112912283madrones
mafficks2243173mafficks
magics115311613ma_gic_s
magpies12310363magpi_es
mailes84329113ma__iles
maizes175115733ma__izes
malaises10312333malaises
malice104818483ma_lice_
malines93625603ma_lines
mamies104626243ma_mi_es
mammies104314763mammi_es
manics103919933ma_nic_s
mannites10312613mannites
manropes1237913manropes
mantises10317923mantises
mantric11311353mantric__
maracas11313773ma_racas
marbles114516653ma_rbles
marcel103714853ma_r_cel
marcels113212373ma_r_cels
marches143921173ma_rches
marcs95726623ma_r_c_s
mares76457633ma_r__es
marges94525713ma_r_ges
marinas93519393ma_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
mastiches1647333mastiches
mastics112614783mastic_s
mastixes1738253mastixes
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
matriarchs1752033matriarchs
matricide1446283matricide
matrix1539853matri__x
matronizes2196823matronizes
matrons93517633matr_ons
mattes85624533mat__tes
mattings11369673mattings
mattins93316143matti_ns
mattocks1644983mattocks
maturates11311763maturates
matures9314313mat_ures
maturities1248453maturities
mavericks2043183mavericks
mavies114923193ma_vi_es
mavises122812993ma_vises
maxixes1535253ma_xixes
mediatrices1653383mediatrices
merces105720743m_er_ces
mercies113817563m_ercies
merises93421423m_erises
metres85121563metr__es
metric10314683metric__
metrical12311593metrical
metricates1449123metricates
metricism1557513metricism
metricizes2346763metricizes
metrifies1439803metrifies
metrists1039853metrists
metritis1049183metritis
misprices1547913misprices
mistraces13312293mistraces
mitises9315543mit_ises
mitres83922073mitr__es
morrises10711073morrises
mortice11711493mortice_
morticed1377163morticed
mortises10713613mortises
motiles93317433mot_iles
motives123611893mot_ives
motorises11311673motorises
motorizes20410783motorizes
murines93718223m_urines
murries94118673murri_es
mutines93117823mut_ines
myricas1436753m_yricas
natives10310823nat_ives
natriums1046293natriums
nitrides92910703nitrides
nitriles8269923nitriles
nitrites82313453nitrites
notices9312283not_ices
orrices9129363_orrices
ostriches1446633ostriches
outprices1337623outprices
outraces102217863outraces
outrides92414993outrides
pantries101817393pantri_es
papricas1447053papricas
paries84742513pa_ri_es
parises94827183pa_rises
parries93925843parri_es
particles1339803particles
parties93230863parti_es
pastries101517423pastri_es
patines95225763pat_ines
patriates11311363patriates
patricides1546283patricides
patriots1038053patriots
patsies93919483patsi_es
patties93425143patti_es
prices104524543__prices
radices102314263ra_dices
ratines75328583rat_ines
ratites74920683rat_ites
ratlines83815293ratlines
rectrices1338873rectrices
reprices122913353reprices
retraces101417273retraces
retries74129073retri_es
rices75536153___rices
saices84221803sa__ices
satires72617573sat_ires
satirises9410193satirises
satirizes1849393satirizes
sauries72821623sauri_es
smarties10312873smarti_es
statices102712343statices
stricks134310693_stricks
strides84520393_strides
strifes104716583_strifes
strikes114719093_strikes
stripes95320573_stripes
strives104119373_strives
tacrines10310563tacrines
tarries73324263tarri_es
tatties74120343tatti_es
taurines8310553taurines
tectrices1346253tectrices
traces85329933__traces
tribes85119023__tribes
trice75127493__trice_
triced95518673__triced
tricep103911073__tricep
triceps11267343__triceps
tricks125319013__tricks
tries55742813__tri_es
trikes105419493__trikes
trines64132563__trines
tripes85324873__tripes
truces84916333__truces
utricles1037223_utricles
varies94330873va_ri_es
vertices13612283vertices
vitrics12198553vitric_s
vitrines112610913vitrines
vortices1369123vortices
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.420425454.8
2DLD Change Limit1461622747.11020557.2
3Display Results2742740.1102490.9
 (SQL Overall)1786912747.64023388.9
 
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.