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 “mucus” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

116 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
mucus9401574(None) 
fucus105515891fucus
mucks134622641mucks
mucous104411651mucous
mumus95517281mumus
amicus103810002amicus
amucks1466002amucks
arcus76918862arcus
ascus75013582ascus
bubus95115452bubus
bucks134824292bucks
caucus1039612caucus
cuscus1038112cuscus
duces86327472duces
ducks124823212ducks
ducts85319892ducts
dufus94010812dufus
ecus65421462_ecus
ficus105015492ficus
focus105815882focus
fucks144419252fucks
fucous11399862fucous
fugus95914012fugus
gucks123917302gucks
gurus64318192gurus
hocus104715202hocus
hucks144322172hucks
humus106215072humus
incus73315052incus
jucos144111712jucos
jujus11347462jujus
jukus16398672jukus
kudus104910802kudus
kurus98015632kurus
locus74819992locus
luaus54514902luaus
luces75528432luces
lucks115723562lucks
lulus54315162lulus
lupus74512522lupus
lusus54813872lusus
maces97139962maces
machs125722562machs
macks135127602macks
macs86742512mac_s
magus85318752magus
manus75924932manus
menus75822842menus
meous76120062meous
micas96823052micas
micks135525372micks
mics87435152mic_s
minus75223932minus
mocks135023822mocks
mocs85834902moc_s
modus85417202modus
momus96116112momus
much115224032muc_h
muches134718992muches
mucho125013442mucho
mucid104115252mucid
mucin93116822mucin
mucins102712512mucins
muck125727852muc_k
mucky165015252mucky
mucluc1245052mucluc
muclucs1343682muclucs
mucor94011942mucor
mucors104410852mucors
mucosa10166272mucosa
mucose10149312mucose
mucro94513722mucro
mucuses11148512mucuses
muds75530652mu_ds
muffs134114212muffs
muggs94912322muggs
mugs76232042mu_gs
mulcts10298712mulcts
mules75034292mules
mulls75124152mulls
mumms85513152mumms
mumps115619102mumps
mums85732772mu_ms
mumu86022062mumu_
munis75022002munis
muns65535922mu_ns
muons75816172muons
muras75329582muras
mures75937222mures
murks114821732murks
murrs75521302murrs
mus55946752m__us
muses75134302muses
musks116119642musks
muss64933762mu_ss
musts75527442musts
mutes75033782mutes
muts64839982mu_ts
mutts75120252mutts
mycs115314292myc_s
puces94924632puces
pucks134322102pucks
pupus94614042pupus
rubus76415062rubus
rucks114422052rucks
ruckus12407792ruckus
sucks114523072sucks
sulcus8410492sulcus
sulus54821882sulus
tucks114721122tucks
tutus55214812tutus
ulus45622562_ulus
uncus74014982uncus
urus46426132_urus
yucas106013912yucas
yucks144717192yucks

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001161.39038705.0
3Display Results1161160.0333515.2
 (SQL Overall)1786911161.719103950.6
 
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.