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

173 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
gnus5651800(None) 
anus47131111anus
genus65319831genus
gnu45522041gnu_
guns55533481guns
nus37939391_nus
onus45826811onus
amus65529612amus
anas46649862anas
ands57833612ands
anes45255932anes
anis45746462anis
ankus91410682ankus
ants47243472ants
bonus75324322bonus
buns66243722buns
bus56950972_bus
conus76726532conus
crus65828482crus
duns55140432duns
ecus65421462ecus
emus66821682emus
ends56528522ends
engs56121392engs
ens37245922en_s
enuf7323842enuf
feus75830752feus
flus75626542flus
funs75235732funs
gabs76740422gabs
gads67843382gads
gaes56348032gaes
gags66441062gags
gals57946502gals
gams76648882gams
gangs76222572gangs
gaps76042972gaps
gars55750742gars
gas48870252g_as
gats56753442gats
gaud67025432gaud
gauds75717722gauds
gaum75726422gaum
gaums86217072gaums
gaun56427712gaun
gaur56723352gaur
gaurs66317992gaurs
gauss65613452gauss
gays87338022gays
geds66730812geds
gees55647882gees
gels56836102gels
gems75329112gems
genes65133092genes
genius74512922genius
gens55740072gens
gents65729612gents
genu55929072genu_
genua64614152genua
gets55442482gets
geum75424552geum
geums85414112geums
ghis85020162ghis
gibs75529272gibs
gids65933742gids
gies55641422gies
gigs66631182gigs
ginks104319562ginks
gins55543952gins
gips75632922gips
gits55744592gits
glue55628492glue
glues65125682glues
glug66118012glug
glugs75214282glugs
glum75825102glum
glums84621422glums
glut56331292glut
gluts66120132gluts
gnar56021382gnar
gnars66718852gnars
gnash9449832gnash
gnat56034432gnat
gnats65217712gnats
gnaw86515742gnaw
gnaws96311142gnaws
goas55239942goas
gobs76935572gobs
gods65438042gods
goes55644092goes
gongs74921612gongs
goos57644912goos
gos47155132g_os
gout56646002gout
gouts64826172gouts
goys86328412goys
grub77220082grub
grubs86312602grubs
grue55825712grue
grues65721962grues
grum75625082grum
gul45832792g_ul
guls55930852guls
gum67439532g_um
gums75030942gums
gun47240802g_un
gunk95423572gunk
gunks104517722gunks
gurus64318192gurus
gush85424002g_ush
gust55240702g_ust
gut46753852g_ut
guts56637252guts
guv74523172g_uv
guvs85816812guvs
guy75728942g_uy
guys85019642guys
gyms107514592gyms
gyps105115022gyps
gyrus95310802gyrus
huns76136932huns
iglus6609932iglus
incus73315052incus
inks86926502inks
inns46920932inns
ins35945602in_s
jus106930222_jus
knur85311972knur
knurs94511152knurs
manus75924932manus
menus75822842menus
minus75223932minus
muns65535922muns
mus55946752_mus
nos38859322_nos
nous46136982nous
nu26331952_nu_
nub56439142_nub
nubs65927142_nubs
nun35537742_nun
nuns45228232_nuns
nut36651962_nut
nuts45032672_nuts
ones46146532ones
onos46229002onos
ons36148512on_s
opus66420592opus
pignus937952pignus
plus66324832plus
puns66641482puns
pus55547842_pus
rhus75114052rhus
runs46438072runs
sinus55523852sinus
snub65320762snub
snubs75412552snubs
snug55218692snug
snugs64913022snugs
sous46947212sous
suns45841902suns
taus46342732taus
thus76721472thus
tonus56324302tonus
tuns45138662tuns
ulus45622562ulus
unaus53216572unaus
uncus74014982uncus
uns35936752un_s
urus46426132urus
us26937432__us
vaus75928922vaus
venus84918902venus
yous76230652yous

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 Filter178691298720.266671770.7
2DLD Change Limit298721730.75039829.3
3Display Results1731730.0463760.9
 (SQL Overall)1786911731.062168258.9
 
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.