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

115 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
magmata123746(None) 
dogmata1145142dogmata
magenta1038622magenta
magma104513572magm__a
magmas115512502magma_s
magmatic1548392magmatic
magnate10512702magnate
mammate104411272mammate
mammati10398372mammati
miasmata1244502miasmata
myomata1445922myomata
regmata1036192regmata
agama85815583_ag_ama
agate66525153_ag_ate
agemate101210583_agemate
aggada955223_aggada
agita6315423_ag_ita
agma77623263_agm__a
agmas85919873_agma_s
agnate73314883_agnate
albata839333_albata
armada938783_armada
bagman114613813bagma_n
balata8614673ba_lata
basmati1148233basmati
bemata10411693_bemata
bregmata1343203bregmata
calamata1247553calamata
cantata93811813cantata
cassata938143cassata
commata1338483commata
edemata1046003edemata
enemata948013enemata
enigmata1143663enigmata
fermata12278143fermata
gagman103811243gagma_n
gummata1244613gummata
haematal1345143haematal
haggada1353643haggada
hamada1239923ha_mada
hamate113319833ha_mate
hammada1545093hammada
hazmat20312263hazmat_
hazmats2136603hazmats
imamate1138103ima_mate
kalamata1445273kalamata
kamala12339963ka_mala
lemmata1144673lemmata
madman113712383madma_n
madrasa10387883madrasa
magentas1137923magentas
maggot10311713maggot_
maggots1136563maggots
maggoty1444013maggoty
magian9312833magia_n
magians10310753magians
magnates11511613magnates
magnet9320663magnet_
magneto1046743magneto
magnets10311143magnets
magot8326393mag_ot_
magots9312363mag_ots
mahatma1443783ma_hatma
makuta1236393ma_kuta
malate84624553ma_late
maleate94117543maleate
mama86231593ma_m__a
mamas95930773ma_ma_s
mamba116317523ma_m_ba
mamma86317913ma_m_ma
mammae94613213mamma_e
mammal95112753mamma_l
mammals10389273mammals
mammary1335993mammary
mammas94616403mamma_s
mammatus1144233mammatus
mammet94319253mammet_
mammets103911113mammets
mammoth1344983mammoth
manana84816073ma_nana
manat76039993ma_nat_
manats84623463ma_nats
mandala10310213mandala
mandate10315573mandate
manmade1237963manmade
manta75629913ma__nta
maraca10314153ma_raca
maranta9311693maranta
marcato1139743marcato
marmite112413993marmite
marmot10318743marmot_
marmots11311513marmots
marsala939583marsala
masala8311813ma_sala
mascara1138023mascara
mastaba1146223mastaba
maumet103518883maumet_
maumets11369693maumets
megara9310093meg_ara
migrate101314173migrate
mismate111415353mismate
myxomata2243383myxomata
nagana748943nag_ana
palmate113215233palmate
ragman94013713ragma_n
ramada9310183ra_mada
ramate83921683ra_mate
samara8313853sa_mara
sigmate10710143sigmate
somata8312383_somata
stigmata1144673stigmata
stomata938533stomata
traumata1045693traumata
trymata1244223trymata
zygomata2342843zygomata

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271156.36021073.4
3Display Results1151150.0462500.0
 (SQL Overall)1786911156.54627297.7
 
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.