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

305 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
matrix153984(None) 
atria56022342_atria
atrip75315752_atrip
iatric8312162iatric
latria62313592latria
mantric11311342mantric
maria75032882ma_ria
martin84122522martin
mastix152310512mastix
matin75132852mat_in
matres84522232matres
matrixes1738062matrixes
matron83918312matron
mattin84416632mattin
metric10314672metric
oratrix1444532oratrix
varix154313512va_rix
abri65522213_abri_
abris75722603_abris
acrid86920103_acrid
admix1557733_admix
aerie54634603_aerie
affix1836003_affix
afrit8323173_afrit
agria65517143_agria
amtrac10109123amtrac
aria46245423_a_ria
arid57642713_a_rid
aril45843023_a_ril
arris56824683_arris
atrial65418943_atrial
atrium8411823_atrium
attic75618353_attic
attrit6315753attrit
auric74521733_auric
auris55331533_auris
aviatrix1842143aviatrix
baric96125693ba_ric
barrio8312573barrio
batik11614733bat_ik
battik1238093battik
calix145317353ca_lix
cantrip112910043cantrip
capric12411803capric
capris10415083capris
carex144822303ca_rex
catkin123512383catkin
catlin83819083catlin
catnip1097973catnip
cattie85221023cattie
cicatrix1942793cicatrix
citric102812313citric
citrin82615413citrin
daric85623113da_ric
daturic1047023daturic
editrix1543643editrix
estrin6315923estrin
fabric1337833fabric
faerie93514683faerie
gastric1038633gastric
gastrin839833gastrin
gematria1175673gematria
hatbox1835133hatbox
hatpin112610613hatpin
hatred104814333hatred
kauri93811853kauri_
kauris103611533kauris
laari54415713laari_
lari45839153la_ri_
laris54737463la_ris
latex124717113lat_ex
lathi85417203lathi_
lathis95516173lathis
lati46438273lat_i_
latrias71913213latrias
latrine7715123latrine
lattin64316223lattin
maar66025063maar__
maars74621633maar_s
macro94718173macr_o
macron103615673macron
macros104017013macros
madras94316433madras
madre85720173madr_e
madres93718183madres
maestri945483maestri_
maffia14327203maffia
mafia104418033ma_fia
mafic125615463ma_fic
maftir1136493maftir
maftirs1236043maftirs
magi76329533ma_gi_
magic105818653ma_gic
magpie1139093magpie
maid75537663ma__id
mail65543453ma__il
maim85831493ma__im
main65345523ma__in
mair66133783ma__ir
mairs76228303mair_s
malaria9313693malaria
malic94525663ma_lic
malkin122913153malkin
mamie95826003ma_mie
mammie94313783mammie
mandril1049353mandril
mania75634153ma_nia
manic94629443ma_nic
mantic104120903mantic
mantid93820383mantid
mantis83926033mantis
mantra84116093mantr_a
mantram114011603mantram
mantrap11379823mantrap
mantras93815863mantras
maqui16249953maqui_
maquis17249483maquis
mar57965953ma_r__
mara67444573ma_r_a
maras75443293ma_ras
marc87034633ma_r_c
march125622893ma_rch
marcs95726623ma_rcs
mare64759333ma_r_e
mares76457633ma_res
marge85328333ma_rge
margin94016843margin
marina84623413ma_rina
marine84230403ma_rine
marish114319053ma_rish
mark105138063ma_r_k
marka114620793ma_rka
marks115933483ma_rks
marl66341623ma_r_l
marlin84220903marlin
marls75535163ma_rls
marly106925613ma_rly
marram10313883marram
marred95421043marred
marrer83716673marrer
married104715303married
marrier93817523marrier
marries93825283marries
marring103319553marring
marron83717543marron
marrow112812603marrow
marry104821693ma_rry
mars66261873ma_r_s
marse76231153ma_rse
marsh105320853ma_rsh
mart66865983ma_r_t
marted94425213marted
marten84518263marten
martial92415413martial
martian93514683martian
marting103325013marting
martini93613873martini
martins93322063martins
marts77442233ma_rts
martyr1135693martyr
marvy135014033ma_rvy
mashie11315933mashie
masjid16187323masjid
massif11412533massif
mastic103119173mastic
mastoid10711233mastoid
mat58083943mat___
match125621103mat_ch
mate65154223mat__e
mated85537783mat_ed
mater74438863mat_er
material10314103material
materiel10311253materiel
maters85032393maters
mates75251363mat_es
matey107022663mat_ey
mateys115610943mateys
math95437453mat__h
maths105624023mat_hs
matier84321523matier
mating94832913mating
matins84527783matins
matrass939403matrass
matrices12312083matrices
matrons93517633matrons
mats65460293mat__s
matsah1138233matsah
matt65752663mat__t
matte75626843mat_te
matted94521413matted
matter84325343matter
mattes85624533mattes
matting103620143matting
mattins93316143mattins
mattoid1079283mattoid
matts76829183mat_ts
mature8313463mature
matured10310033matured
maturer938973maturer
matures9314303matures
maturing1139953maturing
maturity1367433maturity
matza16311813mat_za
matzah2035963matzah
matzas1749703matzas
matzo16312893mat_zo
matzoh2035483matzoh
matzos1749263matzos
matzot17710983matzot
mavie104722563ma_vie
mavin105722953ma_vin
mavis105622723ma_vis
max129045453ma___x
maxi137023563ma_xi_
maxim165216003ma_xim
maxis145721563ma_xis
maxixe1435223ma_xixe
mayvin1436523mayvin
mediatrix1963123mediatrix
megrim1178043megrim
merit7339183m_erit
metis75025903met_is
metre74821303metr_e
metred95315143metred
metres85121563metres
metrics11312363metrics
metrify1535623metrify
metring103215293metring
metrist9317063metrist
metro74718803metr_o
metros84217803metros
midrib1138243midrib
mirex146816623m_irex
miri66730373m_iri_
mirin75023153m_irin
mitis75425993mit_is
mitral81314323mitral
mitre75522423mitr_e
mitred94414343mitred
mitres83922073mitres
mitring103514143mitring
mix126138183m___ix
morris83814733morris
motif10519683mot_if
motoric11312223motoric
murex145517173m_urex
murid84520583m_urid
mythic1637273mythic
naric76824173na_ric
naris55735293na_ris
natrium948983natrium
natron64116023natron
nitric82512063nitric
nitrid72812233nitrid
nitril62511533nitril
nutria639913nutria
outrig72812853outrig
padri85815173padri_
paris75145943pa_ris
patin76832853pat_in
patio74426353pat_io
patois84319363patois
patriot9314533patriot
patrol83213023patrol
patron84018043patron
pattie84020963pattie
putrid9311173putrid
radix134414603ra_dix
ratio55227583rat_io
ratlin64116523ratlin
rectrix1645363rectrix
retrim83514883retrim
sari45444043sa_ri_
sarin55239253sa_rin
saris54544953sa_ris
sati45539333sat_i_
satin55935223sat_in
satire63218003satire
satiric939243satiric
satis55633683sat_is
satori6415843satori_
satoris7317253satoris
satrap86212553satrap
satyric1237493satyric
satyrid1137233satyrid
smartie9310173smartie
stria55723213_stria
strip77524343_strip
tantric939583tantric
tattie64817513tattie
tectrix1644263tectrix
tetri52716453tetri_
tetris62816293tetris
tortrix1444193tortrix
trig55528163__trig
trim65329523__trim
trio45233343__trio
trip66830393__trip
untrim8310683untrim
varia85824203va_ria
vatic10316423vat_ic
vitric112510113vitric
wastrie101210303wastrie
yttria954803yttria
yttric1145433yttric

Search took 7 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.373479064.3
2DLD Change Limit1127163055.72019705.6
3Display Results3053050.0933279.6
 (SQL Overall)1786913056.18628886.4
 
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.