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

428 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
magians1031075(None) 
magian9312831magian_
avians93711562_avians
banians9312032banians
fagins10513862fagi_ns
kalians11310182kalians
lagans75717782lag_ans
mafias113913572mafia_s
magicians1444572magicians
magics115311612magi_cs
magilps1234082magilps
magmas115512502magma_s
mains75635112ma_i_ns
maligns1038132maligns
maniacs114313062maniacs
manias84029032mania_s
mannans93611522mannans
margins103815192margi_ns
marinas93519392marinas
martians103111612martians
matins84527782mati_ns
mavins115119182mavi_ns
medians103214212medians
pagans95717922pag_ans
parians93519732parians
radians83013822radians
raglans82410132raglans
vaginas11298812vaginas
afghans1443573afghans
again65218123_again_
against838383_against
agars66120643_ag_ars
agas55938843_ag_a_s
aghas97014873_agha_s
agin56132713_agi_n_
aging77026353_agi_ng
agings86312673_agings
agios65919863_agi_os
agisms9399393_agisms
agists75713173_agists
agitas7310593_agitas
agmas85919873_agma_s
agons66423783_ag_ons
agrias74315393_agria_s
ains46158883_a_i_ns
airns55521033_a_irns
alans55636173_a_lans
algins74816433algi_ns
alias55834603_alia_s
aliens65619213_aliens
aligns75312953_aligns
amias75831473_amia_s
amigas95912173amiga_s
amins75534323_ami_ns
amnions93710913amnions
anginas8310953anginas
anions64123033_anions
apian75018333_apian_
arias55438023_aria_s
ataghans1244263ataghans
atmans84413963_atmans
avian84616053_avian_
avions94114393_avions
axions134713483_axions
ayins85321613_ayi_ns
azans146516883_a_zans
bagass938933bag_ass
bagman114613813bagman_
bairns86710873ba_irns
banian8315383banian_
banyans1237913banyans
bargains1178643bargains
basins85722763basi_ns
basions94213953basions
begins94415303begi_ns
bogans95714813bog_ans
cabins104418923cabi_ns
caftans12179443caftans
caging105321023cagi_ng
caimans113811783caimans
cains75334303ca_i_ns
cairns85313303ca_irns
callans94518473callans
camions113916133camions
cancans11311873cancans
capias10318353capia_s
captans111612053captans
carinas93622413carinas
cations94524143cations
caviars1238623caviars
caymans14349513caymans
daggas937973dagga_s
damans94715983da_mans
damiana1046563damiana
damianas1155573damianas
durians839573durians
facials123310743facials
facias113415803facia_s
fagin9216573fagi_n_
fanions103713073fanions
farinas103215243farinas
gabions102410053gabions
gaging94718403gagi_ng
gagman103811243gagman_
gains65729513ga_i_ns
gamins94420053gami_ns
gavials1136603gavials
giant65430593__giant
giants74713503__giants
gins55543953__gi_ns
girns64516803__girns
glans65125833__glans
grans64832543__grans
guans64419443__guans
habitans1346623habitans
hagdons1258523hagdons
hariana10310243hariana
harianas1139163harianas
harijans1845723harijans
hazans183411653ha_zans
hazzans18215783hazzans
hogans105914313hog_ans
imaginal1144903imaginal
imagine1037883imagi_ne
imagines1137463imagines
imaging1138083imagi_ng
imagings1234553imagings
imagisms1344903imagisms
imagists1175113imagists
jagras1438463jagra_s
jaguars1535233jaguars
japans1539823ja_pans
jarinas143712193jarinas
jawans1657843ja_wans
kaftans14185353kaftans
kaiaks937043ka_iaks
kains96125643ka_i_ns
kalian10312163kalian_
kanbans1337723kanbans
kations114013663kations
labials9299873labials
lagan66520343lag_an_
lagoons839253lagoons
lagunas8156823lagunas
lallans74113533lallans
lamias85020613lamia_s
laminas93615873laminas
lapins84520683lapi_ns
lariats7615053lariats
latinas74416463latinas
lauans65113533la_uans
layins93817653layi_ns
legions84611783legions
ligans76817733lig_ans
lignans8398853lignans
logans76319063log_ans
logins77820643logi_ns
logions86211293logions
maars74621633ma__ars
macaws1337023ma_caws
macing114221553maci_ng
macons104017243ma_cons
macrons113514893macrons
madams11310943ma_dams
madcaps1435243madcaps
maddens11359753maddens
madman113712383madman_
madras94316433madra_s
maenads1037373maenads
maffias15327283maffia_s
mafia104418033mafia__
magdalens1342833magdalens
mages85036023mag__es
maggots1136563maggots
magi76329533magi___
magic105818663magi__c
magical1239783magical
magician1346133magician_
magilp1137613magi_lp
maglevs1334693maglevs
magma104513573magma__
magmata1237463magmata
magnate10512703magnate
magnates11511613magnates
magnets10311143magnets
magnums1234683magnums
magots9312363mag_ots
magpies12310363magpies
mags75444533mag___s
magueys1333943magueys
magus85318753mag__us
mahuang1372883mahuang
mahuangs1452883mahuangs
maidens10349663maidens
maids86327143ma_i_ds
mailes84329113ma_iles
maills84215283ma_ills
mails76037783ma_i_ls
maims96321793ma_i_ms
main65345523ma_i_n_
mairs76228303ma_i_rs
maists85817573ma_ists
maizes175115733ma_izes
makars124612633ma_kars
making134823853maki_ng
makings145413163makings
malars85020683ma_lars
malices114316623malices
malign939853malign_
maline84529083mali_ne
malines93625603malines
malisons1048783malisons
malkins133311803malkins
mamas95930773ma_ma_s
mambas125716243mamba_s
mamies104626243mami_es
mammals10389273mammals
mammas94616403mamma_s
mammons1048513mammons
manana84816073ma_nana
mananas93414733ma_nanas
manas76240433ma_na_s
manats84623463ma_nats
mangas94122923manga_s
mania75634153mania__
maniac103917973mania_c
manics103919933mani_cs
manikins14189723manikins
manilas93915873manilas
maniocs113611443maniocs
manitos9314053manitos
manitus9310923manitus
mannan85413623mannan_
mannas85019803manna_s
mans66354553m___ans
mansions1069793mansions
mantas85725363manta_s
manuals9311213manuals
maras75443293ma_ra_s
margays1337493margays
margin94016853margi_n_
marginal1137613marginal
marginals1246013marginals
maria75032883maria__
marina84623413mari_na
marine84230403mari_ne
marines93928013marines
markas124717003marka_s
marlins93420473marlins
maroons92615553maroons
marrams11310123marrams
marrano939423marrano
marranos1038423marranos
marrons93216973marrons
martens93714953martens
martian93514683martian_
martins93322063martins
marzipans2242643marzipans
masas75630413ma_sa_s
mascons113411583mascons
masons83916513ma_sons
massas85116463massa_s
matin75132853mati_n_
matinal9312603matinal
mating94832913mati_ng
matings104516213matings
matrass939403matrass
matrons93517633matrons
matsahs1236563matsahs
mattins93316143mattins
matzahs2134483matzahs
matzas1749703matza_s
mavens114312973ma_vens
mavies114923193mavi_es
mavin105722953mavi_n_
mavis105622723mavi__s
mavises122812993mavises
mawing124020803mawi_ng
maximals19325223maximals
maximins1944533maximins
maxims17399673maxi_ms
maxing164817073maxi_ng
maxis145721563maxi__s
maxixes1535253maxixes
mayan105616903ma_yan_
mayas105924383ma_ya_s
maydays1634493maydays
maying124421153mayi_ng
mayings134410513mayings
mayvins1535323mayvins
mazing184418973mazi_ng
means75831233m__eans
medials103914733medials
median94117543median_
mediant103516703mediant
mediants11299493mediants
medias93620783media_s
medinas103411463medinas
megass9219443meg_ass
megilps1233563megilps
menials94015683menials
mesian84315503mesian_
messans92710463messans
miens76118303m__iens
mignons1037863mignons
migrant10314313migrant
migrants1138183migrants
minas75434113m__inas
minions93314623minions
minivans1345413minivans
minyans1237263minyans
mirins83918903miri_ns
moans74624373m__oans
morgans10310123morgans
morions94014643morions
motions94215003motions
mucins102712513muci_ns
muggars11316643muggars
muggins11248073muggins
mughals1355763mughals
myalgias14123893myalgia_s
myriads1334353myriads
naans55815253na__ans
nagana748943nag_ana
naganas847983nag_anas
naiads739013na_iads
nasions73112383nasions
nations74720563nations
organs7912913org_ans
origans839973origans
paeans85118263pa_eans
paesans93312693paesans
pagan86121163pag_an_
pageant10312783pageant
pageants1136693pageants
paginal10269493paginal
paging104020403pagi_ng
pagings114411063pagings
pagurians1243393pagurians
pains75138283pa_i_ns
paisans93614753paisans
papains11312363papains
paphians1545593paphians
pariahs123812343pariahs
parian83223963parian_
partans94418283partans
patinas96318523patinas
patins87528783pati_ns
pavans115715593pa_vans
pavins114919663pavi_ns
pians75126963__pians
radials83614643radials
radian74117273radian_
radiant82817133radiant
radiants9259443radiants
ragas65326063rag_a_s
ragbags1135113ragbags
raging85126433ragi_ng
ragis66325603ragi__s
raglan73711503raglan_
ragman94013713ragman_
ragtags935373ragtags
raias54631123ra_ia_s
rains55140233ra_i_ns
randans8313213randans
ratans63819373ra_tans
rations74123433rations
rattans73411953rattans
ravins94622563ravi_ns
rawins95617623rawi_ns
reagins84215643reagi_ns
regains84316583regains
reginas85614063reginas
regions83613473regions
sabins85521983sabi_ns
sagas66025883sag_a_s
saggars93610683saggars
saigas74114293saiga_s
sains55639973sa_i_ns
salinas73116093salinas
salpians1036763salpians
sampans112411003sampans
sapiens9310173sapiens
sarans64224433sa_rans
sarins63932623sari_ns
sasins64923103sasi_ns
satins64930483sati_ns
saurians837763saurians
savins93923133savi_ns
simians959203simians
tafias93111963tafia_s
taggant9310223taggant
taggants1044933taggants
tagrags936123tagrags
taigas73712563taiga_s
tains54936323ta_i_ns
taipans9269553taipans
takins105117403taki_ns
talions7314113talions
tampans113310983tampans
tarpans92513533tarpans
tartans72615823tartans
tarzans16329923tarzans
titians72710453titians
vagina102710933vagi_na
vaginae11377683vaginae
vaginal11288403vaginal
vagrant11410663vagrant
vagrants1246143vagrants
valiant10314623valiant
valiants1137793valiants
variant10316803variant
variants1139203variants
varias95019903varia_s
vegans103910853veg_ans
vigias104110893vigia_s
waggons1235503waggons
waging114318383wagi_ng
wagons103911213wag_ons
wains86930873wa_i_ns
wangans1149503wangans
wanigans1244743wanigans
wanions104011373wanions
wigans104511703wig_ans
yagis95416573yagi__s
yogins105114103yogi_ns
zamias174212923zamia_s
zayins18409713zayi_ns

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.406440125.6
2DLD Change Limit1340274285.90622693.4
3Display Results4284280.1532797.4
 (SQL Overall)1786914286.46527639.8
 
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.