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

191 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
mughal123626(None) 
mughals1355751mughals
burghal1335072burghal
fugal95613032fug_al
jugal135612402jug_al
moghul1244472moghul
mugful1235402mugful
muggar10316442muggar
mural75225102mu_ral
mutual838502mutual
nuchal11218872nuchal
rugal65916092rug_al
afghan1333873afghan
agha87417303_agha_
aghas97014873_aghas
algal66518213alg_al
argal65023383arg_al
audial7312993audial
aught95120703augh_t
aughts104710243aughts
augural856403augural
aural54428963au_ral
bubal94218213bu_bal
buccal1248243buccal
bugsha1233823bugsha_
bugshas1334513bugshas
buhl95518223bu_h_l
burial84117623burial
bursal84414823bursal
bushel114513943bushel
cuneal8611513cuneal
curial84019153curial
curtal83914543curtal
cushat113513693cushat
cushaw14386983cushaw
cuspal1037883cuspal
dhal86719283__dhal
dual55928173du__al
ducal84816423du_cal
ductal938993ductal
dural64923893du_ral
egal55119433_eg_al
frugal1036393frug_al
fulham1435303fulham
fungal10388733fungal
gal46055513__g_al
ghat86435283__ghat
goal55829303__goal
hyphal1736413hyphal
jubhah2142803jubhah
juga126417323jug_a_
jugful1734603jugful
jughead1933643jughead
jugula1434983jugula
jumbal1758463jumbal
jural125120483ju_ral
kugel1068563kug_el
legal65715943leg_al
lethal939803lethal
lugsail843443lugsail
luteal64411483luteal
magian9312833magian
magical1239783magical
magma104513573magma_
magmas115512503magmas
mammal95112753mammal
manual8313463manual
marshal1238973marshal
mayhap1635233mayhap
meal65643173m__eal
meatal84114733meatal
medal86221323m_edal
medial93819863medial
mega77620873meg_a_
menial84223033menial
mensal84615653mensal
mental84521603mental
mescal104113483mescal
mesial84818083mesial
metal75427383m_etal
methyl1436403methyl
mezcal19367853mezcal
might113827083migh_t
mights123516253mights
mighty154310203mighty
mishap1338863mishap
miskal123710263miskal
missal84314903missal
mitral81314323mitral
mocha1249923mocha_
mochas13310653mochas
modal85919233m_odal
moghuls1343613moghuls
mogul8310213mog_ul
mohel104914833m_ohel
molal75120343m_olal
moral75533433m_oral
mortal84616853mortal
moshav1446053moshav
much115224033much__
muches134718993muches
muchly1686203muchly
mucho125013443much_o
mucosal11155843mucosal
mudcap1335133mudcap
mudcat11311203mudcat
mudhen1236883mudhen
mudhole1344913mudhole
mudra83912433mudra_
mudras94212253mudras
mug65837693mug___
mugfuls1344003mugfuls
mugg86316013mug__g
muggars11316643muggars
mugged114113833mugged
muggee103612833muggee
mugger103914703mugger
muggily1435103muggily
muggs94912323mug_gs
muggur10325593muggur
muggy125612373mug_gy
mugs76232043mug__s
muhly1358523mu_hly
mull65128803mu__ll
mulla74317113mulla_
mullah113710733mullah
mullas84215933mullas
mura65633293mu_ra_
murals84016753mu_rals
muras75329563mu_ras
murra74519083murra_
murras84916003murras
murrha11366453murrha_
murrhas12286163murrhas
musca9311763musca_
muscae10410673muscae
muscat10314653muscat
mush94929123mush__
mushed124420843mushed
musher113820573musher
mushes114124563mushes
mushily152410093mushily
mushy135316633mush_y
musical1139553musical
mussel83412903mussel
mutuals937123mutuals
mutuel837823mutuel
muzhik2473523muzhik
nucha10229793nucha_
nuchae11218513nuchae
nuchals12216933nuchals
ogham1138253_ogham
ought95221533ough_t
oughts104710183oughts
outhaul1039063outhaul
pugh106619233pugh__
pulpal10408453pulpal
pupal97616873pu_pal
quezal2435143quezal
regal65023793reg_al
regnal74812933regnal
ruga56121233rug_a_
rugae65114763rug_ae
rugola736293rugola
rural55821173ru_ral
signal73711483signal
subgoal1046323subgoal
sugar6312913sug_ar
sugh86423443sugh__
sughed113610203sughed
sughs95313323sugh_s
sulcal8311273sulcal
sural55931263su_ral
tubal75517203tu_bal
tussal6288323tussal
ugh76520683_ugh__
ughs85410973_ugh_s
umbral1038623umbral
ungual738183ungual
unhat81119263_unhat
ureal56722683_ureal
urial54823023_urial
usual5310183_usual
uveal84411073_uveal
vagal94613633vag_al
vugh117115723vugh__
vughs12678743vugh_s
vulval12417663vulval
withal1238933withal
yuga85615423yug_a_
yugas95012063yug_as

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.1401276364.3
2DLD Change Limit1127161915.89319127.1
3Display Results1911910.0633031.7
 (SQL Overall)1786911916.09629312.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.