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

158 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
menus7582284(None) 
genus65319831genus
manus75924931manus
mends84927691mends
menu65130231menu_
meous76120061meous
minus75223931minus
venus84918901venus
aeneus61111142aeneus
amends94713282amends
amens75624842amen_s
aments85219802aments
anus47131112_anus
beaus75127112beaus
bends85628972bends
benes75536232benes
bens65945702ben_s
bents76033692bents
bonus75324322bonus
census84310302census
cents74730332cents
conus76726532conus
denes65639722denes
dens55945072den_s
dents65031802dents
ecus65421462_ecus
emends95711432emends
emeus76913332emeus
emus66821682_emus
ends56528522_ends
engs56121392_engs
ens37245922_en_s
enuf7323842_enuf
fends96324972fends
fens76139762fen_s
fetus85816542fetus
feus75830752fe_us
genes65133092genes
genius74512922genius
gens55740072gen_s
gents65729612gents
genu55929072genu_
genua64614152genua
gnus56518002_gnus
hens75642572hen_s
hents87330742hents
jehus15488572jehus
kenos95220622kenos
kens85435232ken_s
lends65326252lends
lenes54738522lenes
lenis56326862lenis
lenos56024862lenos
lens46146492len_s
magus85318752magus
manas76240432manas
manes76648962manes
manos74933622manos
mans66354552man_s
meads85425322meads
meals75933372meals
means75831232means
meats75034052meats
meatus85112922meatus
medius93613282medius
meds75735362me_ds
medusa936292medusa
meeds84920272meeds
meets74224612meets
megs75530632me_gs
melds84822382melds
mells75031332mells
mels65941532me_ls
melts74930102melts
memes94927702memes
memos95719112memos
mems85931502me_ms
men59252852men__
menad85918982menad
menads95514382menads
mend75334032men_d
meno66031362men_o
mensa75318672mensa
mensas85115862mensas
mense75025632mense
menses84222452menses
mensh105413562mensh
menta74424422menta
mentum104511712mentum
menudo945792menudo
menudos1034642menudos
meou65325862meou_
meows104612682meows
mercs96020452mercs
meres75143572meres
merks114722402merks
merls77423902merls
mesas76823202mesas
mesnes85216212mesnes
mess65932432me_ss
metes74736212metes
meths105320232meths
metis75025902metis
mewls105813232mewls
mews96629332me_ws
mezes167719262mezes
miens76118302mien_s
minas75434112minas
minds85427122minds
mines75651952mines
minis75432992minis
minks115829272minks
mints76834042mints
modus85417202modus
momus96116112momus
monas74732152monas
monks116123392monks
monos75930862monos
mons68152262mon_s
mucus94015742mucus
mumus95517282mumus
munis75022002munis
muns65535922mun_s
mus55946752m__us
mynas105815232mynas
negus64513562negus
nenes55329672nenes
nevus84611392nevus
nexus124710662nexus
nus37939392__nus
omens75618962omen_s
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 4 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.623286823.4
2DLD Change Limit538001583.01617838.2
3Display Results1581580.0931698.9
 (SQL Overall)1786911583.73247880.8
 
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.