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

210 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
muggars1131664(None) 
muggar10316441muggar_
muggers113611931muggers
muggurs11315101muggurs
beggars11378222beggars
buggers114315662buggers
eggars8398972_eggars
huggers124211592huggers
luggers93713482luggers
muggees11338882muggees
mugger103914702mugger_
muggins11248072muggins
muggs94912322mugg__s
muggur10325592muggur_
mughals1355752mughals
ruggers94612312ruggers
saggars93610682saggars
seggars9377782seggars
sugars7312422su_gars
tuggers93711442tuggers
vulgars11306532vulgars
agars66120643__agars
aggers85817793_aggers
alegars838933alegars
augers73818703au_gers
augurs7399963au_gurs
baggers113915693baggers
beggar10328223beggar_
beggary14316153beggary
budgers114314923budgers
bugbears1333693bugbears
bugger104418723bugger_
buggery14367933buggery
buggies114613813buggies
buglers105115323buglers
bulgers105215143bulgers
bulgurs10397113bulgurs
burgers103918573burgers
burglars1154593burglars
bursars94510893bursars
busbars1138153busbars
chuggers1554853chuggers
cigars9910713_cigars
cougars1038423cougars
daggas937973dagga_s
daggers103714913daggers
diggers104413383diggers
dogears937513dogears
doggers104413433doggers
durbars1077973durbars
eggar7458883_eggar_
eggers84612583_eggers
foggers124112013foggers
fulmars1246423fulmars
fungals11276783fungals
gaggers103413663gaggers
gars55750743___gars
gears64628693__gears
gnars66718853__gnars
guars65021043__guars
guggles103410543guggles
guitars8116853guitars
haggard13377183haggard
haggards14366763haggards
hangars114313483hangars
hoggers124512483hoggers
hugger114713123hugger_
hungers114013303hungers
hussars10326973hussars
jaggary19304863jaggary
jaggers164012893jaggers
jaguars1535223jaguars
jiggers164010173jiggers
joggers164110693joggers
judgers16369043judgers
jugglers17366523jugglers
juggles164510843juggles
jugulars1643233jugulars
keggers13357033keggers
kurgans12145653kurgans
laggard10347623laggard
laggards11307053laggards
laggers94216243laggers
loggats9286453loggats
loggers94616133loggers
lugers74617023lu_gers
luggage1043673luggage
luggages1143633luggages
lugger83916553lugger_
luggies93011213luggies
lumbars11289763lumbars
lunars65012813lu_nars
lungans8399053lungans
lungers83817083lungers
maars74621633m__aars
maggots1136553maggots
magians10310753magians
magmas115512503magma_s
makars124612633m_akars
malars85020683m_alars
mangas94122923manga_s
mangers103521263mangers
margays1337493margays
mars66261863m___ars
medlars10259443medlars
megabars1344403megabars
megara9310093m_egara
megass9219443m_egass
mergers103813423mergers
miggles113512033miggles
miggs96311373migg__s
mimbars1397373mimbars
moggies113111723moggies
molars85517323m_olars
mongers104217273mongers
morgans10310123morgans
mortars93411523mortars
muckers153612793muckers
mucors104410843mu_cors
mudcaps1444103mudcaps
mudcats1236223mudcats
mudders113211103mudders
mudguard1341783mudguard
mudguards1441503mudguards
mudlark1463913mudlark
mudlarks1542883mudlarks
mudras94212253mudra_s
mugfuls1344003mugfuls
mugg86316013mugg___
mugged114113833mugg_ed
muggee103612833mugg_ee
muggier11288943muggier
muggiest12228533muggiest
muggily1435103muggily
mugging122711793mugging
muggings13244593muggings
muggy125612373mugg__y
mughal1236263mugha_l
mugs76232043mu_g__s
mugwort1346753mugwort
mugworts1443443mugworts
mullahs12388733mullahs
mullas84215933mulla_s
mullers93217303mullers
mummers103712843mummers
mumpers133311363mumpers
mungoes103510463mungoes
mungos94311373mung_os
murals84016753mu_rals
muras75329563mu_ra_s
murders103311363murders
murmurs1134523murmurs
murras84916003murra_s
murrs75521293mu__rrs
muscats1138933muscats
musers84719093mu_sers
mushers124016433mushers
mustard10359533mustard
mustards11297883mustards
musters94522493musters
mutters94117133mutters
mutuals937123mutuals
mylars114310443m_ylars
naggers93812653naggers
niggard1044943niggard
niggards1144113niggards
niggers93111313niggers
nudgers9479373nudgers
nuggets936383nuggets
outgas7313203outga_s
outwars10912793outwars
pluggers12297023pluggers
puggaree12174333puggaree
puggarees13173043puggarees
puggry13374823pugg_ry
pugmark1643463pugmark
pugmarks1742533pugmarks
pulsars9358913pulsars
purgers104714003purgers
quaggas1893703quagga_s
quasars1646903quasars
regears83012463regears
reggaes948883reggaes
riggers93613833riggers
rugger84414513rugger_
saggar84010853saggar_
saggard10358953saggard
saggards11397493saggards
saggers94017083saggers
sangars83116253sangars
seggar8357813seggar_
sluggard1142613sluggard
sluggards1242283sluggards
sluggers10348483sluggers
smugger11327053smugger_
smugglers13263433smugglers
smuggles12225443smuggles
sugar6312913su_gar_
sugary1039013su_gary
surgers83517483surgers
taggers93514193taggers
tugger84013103tugger_
turgors836823turgors
tussars7359243tussars
unbars82113033_unbars
urgers73313623_urgers
vuggs10579133vugg__s
vulgar10426823vulgar_
waggers124613083waggers
yugas95012063yu_ga_s

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.1561145455.1
2DLD Change Limit1340272106.53320515.4
3Display Results2102100.0762763.2
 (SQL Overall)1786912106.76526414.0
 
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.