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

131 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
genus6531983(None) 
genes65133091genes
genius74512921genius
gens55740071gen_s
gents65729611gents
genu55929071genu_
genua64614151genua
gnus56518001g_nus
menus75822841menus
venus84918901venus
aeneus61111142aeneus
agenes74720252agenes
agents74816292agents
anus47131112_anus
beaus75127112beaus
bends85628972bends
benes75536232benes
bens65945702ben_s
bents76033692bents
bonus75324322bonus
census84310302census
cents74730332cents
conus76726532conus
denes65639722denes
dens55945072den_s
dents65031802dents
ecus65421462_ecus
emus66821682_emus
ends56528522_ends
engs56121392_engs
ens37245922_en_s
enuf7323842_enuf
fends96324972fends
fens76139762fen_s
fetus85816542fetus
feus75830752fe_us
gangs76222582gangs
gears64628692gears
gecks125117092gecks
geds66730812ge_ds
geeks104915842geeks
gees55647882ge_es
gelds75118342gelds
gels56836102ge_ls
gelts65924612gelts
gems75329112ge_ms
gen45950512gen__
gene56237222gen_e
genet66038682genet
genets75716662genets
genic85119392genic
genie66124922genie
genies75324942genies
genii64514172genii
genip84415202genip
genips9469942genips
genoa64315822genoa
genoas74013622genoas
genom83716842genom
genoms94412482genoms
genre66016802genre
genres75515622genres
genro64914032genro
genros74211332genros
gent56954392gen_t
gentes75324162gentes
genuses83510882genuses
germs85118872germs
gests66028812gests
getas65421482getas
gets55442482ge_ts
getup83410262getup
getups9346852getups
geum75424552ge_um
geums85414112geums
ginks104319562ginks
gins55543952gin_s
glens66519852glen_s
gnu45522042g_nu_
gongs74921612gongs
gunks104517722gunks
guns55533482gun_s
gurus64318192gurus
gyrus95310802gyrus
hens75642572hen_s
hents87330742hents
jehus15488572jehus
kenos95220622kenos
kens85435232ken_s
lends65326252lends
lenes54738522lenes
lenis56326862lenis
lenos56024862lenos
lens46146492len_s
manus75924932manus
mends84927692mends
menu65130232menu_
meous76120062meous
minus75223932minus
negus64513562negus
nenes55329672nenes
nevus84611392nevus
nexus124710662nexus
nus37939392__nus
onus45826812_onus
pends85527192pends
penes75839222penes
penis75129322penis
pens65649642pen_s
rebus75721112rebus
rends65129952rends
rents55935182rents
sends65528242sends
sinus55523852sinus
tends65425582tends
tendus75111182tendus
tens45647412ten_s
tents56434212tents
tenues63816442tenues
tenuis64213082tenuis
tonus56324302tonus
vends95520892vends
venous93713192venous
vents86125932vents
venue84918212venue
venues95115202venues
wends95822812wends
wens76337932wen_s
xerus12313332xerus
yens75832262yen_s
zebus164610052zebus

Search took 5 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.966184980.3
2DLD Change Limit538001313.75014346.7
3Display Results1311310.0333969.7
 (SQL Overall)1786911314.74937627.1
 
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.