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

197 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
magnum113673(None) 
magnums1234681magnums
fanum10313442fa_num
magnet9320662magnet
magus85318752mag_us
manus75924932ma_nus
regnum957162regnum
sagum8512872sag_um
agendum1144673_agendum
agism84614063_agism
ague55725923_ag_ue
album92312653_album
algum82711763_algum
alum65227613_a_lum
amylum1344693amylum
annul55813383_annul
anus47131113_a_nus
arum66129033_a_rum
aurum7614963_aurum
bagful1237213bagful
bagnio937523bagnio
barium10313513barium
begum105213923beg_um
caecum1238183caecum
cangue91012443cangue
crinum1039333crinum
dadgum1134583dadgum
datum8310633da_tum
degum94711903deg_um
fanums1137263fa_nums
fraenum1255703fraenum
frenum1188803frenum
gangue81310573gangue
gaum75726423__gaum
geum75424553__geum
glum75825103__glum
gnu45522043__gnu_
gnus56518003__gnus
granum9310913granum
grum75625083__grum
gum67439533__g_um
hafnium1544243hafnium
hagbut1278923hagbut
hahnium1544433hahnium
hangul1049213hangul
hangup1277293hangup
hognut1039413hognut
imagism1285083imagism
imaum9139643ima__um
jugum15167473jug_um
kagu95418113kag_u_
kagus105812033kag_us
kalium1239473kalium
labium10410243labium
labrum1057423labrum
ladanum1045183ladanum
laguna7127223laguna
lagune7158633lagune
langue71012173langue
langur7109303langur
larum74317973la_rum
linum7313823_linum
madam10316223ma_dam
madtom1138023madtom
maenad939413maenad
mag67956483mag___
mage75739133mag__e
magenta1038623magenta
mages85036023mag_es
maggot10311713maggot
magi76329533mag__i
magian9312833magian
magic105818653mag_ic
magics115311613magics
magilp1137613magilp
maglev1237023maglev
magma104513573mag_ma
magmas115512503magmas
magnate10512703magnate
magnesium1453733magnesium
magneto1046743magneto
magnets10311143magnets
magnify1634533magnify
magot8326393mag_ot
magots9312363magots
magpie1139093magpie
mags75444533mag__s
maguey1236833maguey
mahout11415803mahout
maihem1366213maihem
maim85831493ma__im
main65345523main__
mainly11411493mainly
mains75635113main_s
makeup1434863makeup
malm85129983ma__lm
mamluk1434743mamluk
man57465873ma_n__
mana65341963ma_n_a
manas76240433ma_nas
manat76039993ma_nat
mane65052033ma_n_e
maned86634103ma_ned
manes76648963ma_nes
manful11610213manful
manga85026203ma_nga
mangas94122923mangas
mange84930193ma_nge
mangel94017533mangel
manger94325003manger
manges94628943manges
mangey123614523mangey
mangle93921323mangle
mango85724323ma_ngo
mangos94319333mangos
mangy115021243ma_ngy
mania75634153ma_nia
manic94629443ma_nic
manly105022953ma_nly
manna75522543ma_nna
mannan85413623mannan
mannas85019803mannas
manned94418643manned
manner84020513manner
mano66536813ma_n_o
manor78023933ma_nor
manos74933623ma_nos
manque17259513manque
mans66354553ma_n_s
manse75528233ma_nse
manta75629913ma_nta
mantua84412023mantua
manual8313463ma_nual
manumit1149573ma_numit
manure8313653ma_nure
many95731863ma_n_y
maqui16249953ma_qui
maraud938943maraud
markup1436903markup
marque172410503marque
marram10313883marram
masque17249383masque
maud75325403ma__ud
maul64830723ma__ul
maun65727213ma__un
maund85515453maun_d
maunds9519653maunds
maundy12506783maundy
maut65448453ma__ut
mawn94424143mawn__
maxim165216003ma_xim
maximum1743573maximum
mayhem1644923mayhem
mazuma1935603ma_zuma
medium113711623medium
megohm14124193megohm
megrim1178043megrim
mentum104511713mentum
menu65130233m_enu_
menus75822843m_enus
mignon937953mignon
milium104712683milium
minim97321603m_inim
minium106014423minium
minus75223933m_inus
moghul1244473moghul
mogul8310213mog_ul
mugful1235403mugful
muggur10325593muggur
mugwump1741213mugwump
mum76643613m___um
muonium1146863muonium
museum1037703museum
oakum1177313oa_kum
omasum1035503oma_sum
organum1045343organum
pablum1237503pablum
paynim1337363paynim
pignus937953pignus
pignut9311573pignut
plenum1039503plenum
radium93513293radium
ragout7317183ragout
sacrum103910143sacrum
sagbut959753sagbut
sannup836563sannup
siglum936563siglum
sphagnum1641533sphagnum
stannum944643stannum
talcum1036953talcum
vacuum1334833vacuum
vagrom1235943vagrom
vague96513113vag_ue
vagus96713813vag_us
walnut939433walnut
wampum15406053wampum
wangun1037103wangun

Search took 6 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.376475242.0
2DLD Change Limit1127161974.78023580.8
3Display Results1971970.0633127.0
 (SQL Overall)1786911975.21934238.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.