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

295 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
maggot1031170(None) 
faggot1139041faggot
maggots1136551maggots
maggoty1444001maggoty
magot8326391ma_got
argot67728642_argot
faggots1234852faggots
faggoty1542852faggoty
fagot9323402fa_got
magnet9320662magnet
magots9312362ma_gots
mango85724312mango_
mangos94319332mangos
marmot10318742marmot
mascot104016072mascot
matzot17710982matzot
waggon1136392waggon
abbot9318453_abbot
afoot8420113_afoot
agent65829643_agent
aggadot1045133_aggadot
agger76420893_agger
aggie73415013_aggie
aggro738003_aggro
aggros836543_aggros
agio57828453_agio_
agios65919863_agios
agist66325583_agist
aglet65534143_aglet
aglow94711963_aglow
ago48845523_a_go_
agog68019003_a_gog
agon56531883_a_gon
agorot7414993_agorot
algor6513053_algor
allot54933873_allot
amigo86515453amigo_
amigos94511203amigos
angst6415493_angst
argol65317263_argol
argon65520593_argon
argots74116023_argots
ascot76522513_ascot
aught95120703_aught
bagged114519903bagged
bagger104619203bagger
baggie102912193baggie
baggy125615683bagg_y
baguet9316103baguet
ballot84624093ballot
begot84625953_begot
bigot84828323_bigot
cahoot11416473cahoot
cannot83616773cannot
cargo85322073cargo_
cargos94619183cargos
carrot8423123carrot
catgut9310793catgut
caught124911683caught
dagga839543dagg_a
daggas937973daggas
dagger95017293dagger
daggle93711903daggle
dago65725083da_go_
dagos76419443da_gos
diglot83014333diglot
doggo84410703doggo_
eaglet73722583eaglet
ergot65422893_ergot
fagged124717703fagged
faggoted1443103faggoted
faggotry1641673faggotry
faggy136514373fagg_y
fagots1039963fa_gots
forgot104318133forgot
gadget93616173gadget
gagged104817153gagged
gagger95016513gagger
gaggle93412623gaggle
galiot72322583galiot
galoot72719153galoot
garget84327273garget
gavot9321113ga_vot
giglot84013133giglot
gigot74023073_gigot
got49870443___got
grot55942053__grot
hagbut1278913hagbut
hagdon1188283hagdon
haggadot1444033haggadot
hagged124317703hagged
haggis11209513haggis
haggle113511983haggle
hallot95426783hallot
hangout11411393hangout
harlot94422803harlot
hogget114715763hogget
imagist1077323imagist
imago8118683ima_go_
imagos9117543ima_gos
ingot61221063_ingot
jabot14321513ja_bot
jagg136115313jagg__
jagged164115353jagged
jagger154016003jagger
jaggs148111493jagg_s
jaggy175913143jagg_y
jargon1448823jargon
lagged95520133lagged
lagger85919833lagger
lagoon7410483lagoon
largo65319783largo_
largos74815063largos
macho126120153macho_
machos135217493machos
macon94519953ma_con
macro94718173macro_
macron103615673macron
macros104017013macros
madtom1138023madtom
madwort13611363madwort
mag67956473ma_g__
magalog1144903magalog
mage75739123ma_g_e
magenta1038623magenta
mages85036023ma_ges
magi76329523ma_g_i
magian9312833magian
magic105818653ma_gic
magics115311613magics
magilp1137613magilp
maglev1237023maglev
magma104513573ma_gma
magmas115512503magmas
magmata1237463magmata
magnate10512703magnate
magneto1046743magneto
magnets10311143magnets
magnum1136733magnum
magpie1139093magpie
mags75444523ma_g_s
maguey1236833maguey
magus85318753ma_gus
mahoe10315573ma_hoe
mahout11415803mahout
mahzor2035113mahzor
maigre9309163maigre
maillot9312173maillot
maist75535673ma_ist
major145212923ma_jor
mako105622353ma_ko_
makos116518363ma_kos
malgre9299303malgre
mallet84433053mallet
mallow114014743mallow
maloti8313193ma_loti
malt66254803ma__lt
maltol8310843maltol
mambo115215733mambo_
mambos125414493mambos
mammet94319253mammet
mammon939643mammon
mammoth1344983mammoth
manat76039983ma_nat
manga85026193mang_a
mangas94122923mangas
mange84930183mang_e
mangel94017533mangel
manger94325003manger
manges94628943manges
mangey123614523mangey
mangle93921323mangle
mangoes104316133mangoes
mangold1137203mangold
mangy115021233mang_y
manihot121112053manihot
manioc103914823manioc
manito8518693manito
mano66536793ma_no_
manor78023923ma_nor
manos74933613ma_nos
margay12310593margay
marge85328333marg_e
margent10316693margent
marges94525713marges
margin94016843margin
market123226043market
marmots11311513marmots
maroon83118203maroon
marplot1149673marplot
marron83717543marron
marrow112812603marrow
mart66865973ma__rt
mascon103612743mascon
mascots113910343mascots
mason74820183ma_son
mast65959953ma__st
mat58083933ma___t
matelot9411573matelot
matron83918313matron
matt65752653ma__tt
matzo16312893matzo_
matzoh2035483matzoh
matzos1749263matzos
matzoth2144333matzoth
mauger93813483mauger
maugre9308973maugre
maumet103518883maumet
maut65448443ma__ut
mayest114614793mayest
mayo96524293ma_yo_
mayor106616623ma_yor
mayos105521933ma_yos
maypop1565143maypop
mayst106622673ma_yst
merlot83217603merlot
midget103718443midget
midgut103510053midgut
migg85716793migg__
miggle104012113miggle
miggs96311373migg_s
might113827083m_ight
mignon937953mignon
mikvot1556763mikvot
mogged115215393mogged
moggie103210103moggie
moggy125212163mogg_y
mongo810122413mongo_
mongoe94214983mongoe
mongol94912533mongol
mongos94318623mongos
mongst93512603mongst
moot67653623m__oot
mot57279423m___ot
motmot10311073motmot
mugg86316013mugg__
muggar10316443muggar
mugged114113833mugged
muggee103612833muggee
mugger103914703mugger
muggs94912323mugg_s
muggur10325593muggur
muggy125612373mugg_y
mugwort1346753mugwort
mungo84916053mungo_
mungos94311373mungos
nagged93916053nagged
nagger84016123nagger
naggy106612823nagg_y
naught104312493naught
nugget8311723nugget
pagod95013683pa_god
parget94529393parget
pargo86723723pargo_
pargos95719043pargos
parrot8320663parrot
ragg65622693ragg__
ragged94620263ragged
raggee84217603raggee
raggle83712883raggle
raggs75216473ragg_s
raggy106116573ragg_y
ragout7317183ragout
ragtop936683ragtop
ragwort11510733ragwort
sabot7931773sa_bot
sagbut959753sagbut
sagest74920263sagest
saggar84010853saggar
sagged94120003sagged
sagger84321073sagger
saggy105917463sagg_y
sago56332673sa_go_
sagos66123873sa_gos
sargo65424413sargo_
sargos74318273sargos
spigot9312603spigot
taggant9310213taggant
tagged93418123tagged
tagger84017693tagger
tango66921173tango_
tangos74216303tangos
target75028903target
tarot55943933ta_rot
taught104312223taught
ungot61718063_ungot
vagrom1235943vagrom
wagged124616123wagged
wagger113616013wagger
waggle113612303waggle
waggly14347293waggly
waggons1235503waggons
wagon94312953wa_gon
waught133811043waught
zagged183612513zagged

Search took 9 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 Limit1127162958.06313979.4
3Display Results2952950.0933172.0
 (SQL Overall)1786912958.29621539.4
 
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.