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

226 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
maggots113656(None) 
faggots1234861faggots
maggot10311711maggot_
maggoty1444011maggoty
magots9312361ma_gots
argots74116032_argots
faggot1139052faggot_
faggoty1542862faggoty
fagots1039962fa_gots
magnets10311142magnets
magot8326392ma_got_
mangoes104316132mangoes
mangos94319342mango_s
marmots11311512marmots
mascots113910342mascots
waggons1235502waggons
abbots1039293_abbots
agents74816293_agents
aggers85817793_aggers
aggies83515513_aggies
aggros836553_aggros
agios65919863_agio_s
agists75713173_agists
aglets73915683_aglets
agons66423783_a_gons
algors7312553_algors
allots64019173_allots
amigos94511213amigo_s
angsts738863_angsts
argols74514613_argols
argons75018203_argons
argot67728653_argot_
ascots85312513_ascots
aughts104710243_aughts
baggers113915693baggers
baggies113814853baggies
baguets1037483baguets
ballots94116033ballots
bigots95015133_bigots
cahoots1238473cahoots
cargoes104415223cargoes
cargos94619183cargo_s
carrots9714623carrots
catguts1045323catguts
daggas937973dagg_as
daggers103714913daggers
daggles103611913daggles
dagoes85714603da_goes
dagos76419443da_go_s
diglots9299503diglots
eaglets84111663eaglets
ergots74512373_ergots
faggoted1443103faggoted
faggotry1641673faggotry
fagot9323403fa_got_
gadgets10348683gadgets
gaggers103413663gaggers
gaggles103512593gaggles
galiots82311323galiots
galoots82410793galoots
gargets94614573gargets
gavots1038113ga_vots
giglots9367863giglots
gigots83911953_gigots
grots65025853__grots
hagbuts1354933hagbuts
hagdons1258523hagdons
haggis11209513hagg_is
haggles123312483haggles
hangouts1236183hangouts
harlots103413293harlots
hoggets12498323hoggets
imagists1175113imagists
imagoes10126403ima_goes
imagos9117553ima_go_s
ingots7912063_ingots
jabots1538883ja_bots
jaggers164012893jaggers
jaggies163311083jaggies
jaggs148111493jagg__s
jargons1558203jargons
laggers94216243laggers
lagoons839253lagoons
largos74815063largo_s
loggats9286453loggats
loggets9378913loggets
machos135217493macho_s
macons104017243ma_cons
macrons113514893macrons
macros104017013macro_s
madtoms1236923madtoms
madworts1456173madworts
magalogs1245253magalogs
magenta1038623magenta
magentas1137923magentas
mages85036023ma_g_es
magians10310753magians
magics115311613ma_gics
magilps1234083magilps
maglevs1334693maglevs
magmas115512513ma_gmas
magmata1237463magmata
magnate10512703magnate
magnates11511613magnates
magnet9320663magnet_
magneto1046743magneto
magnetos1146263magnetos
magnums1234683magnums
magpies12310363magpies
mags75444533ma_g__s
magueys1333943magueys
magus85318753ma_g_us
mahoes11313103ma_hoes
mahouts1237143mahouts
mahzors2135123mahzors
maillots1037473maillots
maists85817573ma_ists
majors154511093ma_jors
makos116518363ma_ko_s
mallets93318493mallets
mallows123714323mallows
maloti8313213ma_loti
maltols939403maltols
malts76331753ma__lts
mamboes135011823mamboes
mambos125414493mambo_s
mammets103911113mammets
mammons1048513mammons
mammoth1344983mammoth
mammoths1442853mammoths
manats84623463ma_nats
mangas94122933mang_as
mangels103614493mangels
mangers103521263mangers
manges94628953mang_es
mangles104021463mangles
mango85724333mango__
mangold1137213mangold
mangolds1235193mangolds
manihots13126443manihots
maniocs113611443maniocs
manitos9314053manitos
manors84420883ma_nors
manos74933623ma_no_s
margays1337493margays
margents11410133margents
marges94525713marg_es
margins103815193margins
markets133314033markets
marmot10318753marmot_
maroons92615553maroons
marplots1245633marplots
marrons93216973marrons
marrows122911833marrows
marts77442233ma__rts
mascons113411583mascons
mascot104016073mascot_
masons83916513ma_sons
masts77035763ma__sts
matelots1047543matelots
matrons93517633matrons
mats65460293ma___ts
matts76829183ma__tts
matzohs2134373matzohs
matzos1749263matzo_s
matzot17710983matzot_
matzoth2144333matzoth
maumets11369693maumets
mauts75927193ma__uts
mayors115714193ma_yors
mayos105521933ma_yo_s
maypops16104453maypops
merlots92710123merlots
midgets113910253midgets
midguts11296013midguts
miggles113512033miggles
miggs96311373migg__s
mights123516253m_ights
mignons1037863mignons
moggies113111723moggies
mongoes103415713mongoes
mongols103310823mongols
mongos94318623mongo_s
moots75831663m__oots
motmots1166133motmots
mots66853163m___ots
muggars11316643muggars
muggees11338883muggees
muggers113611933muggers
muggins11248073muggins
muggs94912323mugg__s
muggurs11315103muggurs
mugworts1443443mugworts
mungoes103510463mungoes
mungos94311373mungo_s
naggers93812653naggers
naughts11447513naughts
nuggets936383nuggets
pagods105310193pa_gods
pargets105215193pargets
pargos95719043pargo_s
parrots9312743parrots
raggees93710913raggees
raggies93214733raggies
raggles93813283raggles
raggs75216473ragg__s
ragouts838543ragouts
ragtops1035453ragtops
ragworts12125803ragworts
sabots8314703sa_bots
sagbuts1065223sagbuts
saggars93610683saggars
saggers94017083saggers
sagos66123873sa_go_s
sargos74318273sargo_s
spigots1037793spigots
taggants1044933taggants
taggers93514193taggers
tangos74216323tango_s
targets84314223targets
tarots66422993ta_rots
waggers124613083waggers
waggles123812003waggles
waggon1136393waggo_n
wagons103911213wa_gons
waughts14355963waughts

Search took 8 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.436409841.7
2DLD Change Limit1340272267.15618729.3
3Display Results2262260.0932430.1
 (SQL Overall)1786912267.68523251.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.